mysql select category count from source_text group by category -------

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
mysql> select category, count(*) from source_text group by category;
+------------------+----------+
| category | count(*) |
+------------------+----------+
| Arts | 198 |
| Business | 83 |
| Computers | 41 |
| Games | 27 |
| Health | 95 |
| Home | 10 |
| INVALID CATEGORY | 123 |
| News | 8 |
| Recreation | 88 |
| Reference | 39 |
| Regional | 192 |
| Science | 9 |
| Society | 93 |
| Sports | 69 |
+------------------+----------+
14 rows in set (0.00 sec)