Broj primjeraka po zbirkama

mysql> select ccode,count(*) from items group by ccode ;                                                                      
+-------+----------+
| ccode | count(*) |                                                                                                          +-------+----------+                                                                                                          
| ANG   |    23588 | 
| ARH   |     5259 | 
| FIL   |    10369 | 
| FON   |     6857 | 
| IZN   |     5659 | 
| KLF   |    10627 | 
| KOM   |    14280 | 
| PED   |    10781 | 
| POV   |    16399 | 
| SLF   |    55448 | 
| SOC   |     8734 | 
| SRC   |     1549 | 
+-------+----------+
12 rows in set (0.56 sec)