how to find count of agent having sum(amount)>10000

Question

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