MYSQL使用SUM选择查询

| campaign_id | catgory_id 
--------------------------
| 1       | xxx         
| 2       | xxx       
| 3       | xxx       
| 4       | yyy      
| 5       | yyy       
| 6       | yyy         
| 7       | yyy     

I need the following output:

xxx > Total: 3
yyy > Total: 4

Please try this query. I hope it's will help you.

SELECT catgory_id,COUNT(*) FROM tbl_name GROUP BY catgory_id; 

Thank you!

Your question is very basic in sql . But solution is

SELECT catgory_id,COUNT(*) as total FROM tbl_name GROUP BY catgory_id;

This will be working fine.