count values using sql query

Question

I want to count how many policy  was created by  agent

table is 

 

PolicyNo	AgentCode
9087	46456
12345	46456
234234	1

 

 

output should be 

 

NoPolicy	AgentCode
2	46456
1	1