Hello,
I have a problem that how to find count of agents having sum(amount)>10000 with sql query
| Teamname | Agentname | Amount |
| Shweta | Anita | 10000 |
| Shweta | Pinky | 7000 |
| Shweta | Pinky | 3000 |
| Shweta | Pinky | 5000 |
| Shweta | Sanjay | 12000 |
| Shweta | Kiran | 15000 |
| Shweta | Ana | 8000 |
| Abnesh | Susmita | 7000 |
| Abnesh | Rekha | 12000 |
| Abnesh | Vibha | 13000 |
the output must come like this
| Teamname | Qualifiers |
| Shweta | 4 |
| Abnesh | 2 |
Midhun TpPosted Sep 13, 2016, 6:31 AM