SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category
SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category <table_name> : music_festival col : ID | Music_Festival | Date_of_ceremony | Category | Volume | Result row 1 : 1 | 34th England Academy Prize | 18 February 2011 | Best Song | 1 | Nominated row 2 : 2 | 34th Japan Academy Prize | 18 February 2011 | Best Lyrics | 2 | Nominated row 3 : 3 | 34th European Academy Prize | 18 February 2011 | Best Song | 3 | Awarded row 4 : 4 | 36th Japan Academy Prize | 18 February 2011 | Best Song | 4 | Awarded row 5 : 5 | 34th USA Academy Prize | 18 February 2011 | Best Song | 5 | Nominated row 6 : 6 | 40th Japan Academy Prize | 18 February 2011 | Best Song | 6 | Nominated row 7 : 7 | 37th Sweden Academy Prize | 18 February 2011 | Best Lyrics | 7 | Nominated row 8 : 8 | 37th Canadian Academy Prize | 18 February 2011 | Best Lyrics | 8 | Nominated row 9 : 9 | 35th China Academy Prize | 18 February 2011 | Best Sound Song | 9 | Awarded
col : Category | COUNT(*) row 1 : Best Lyrics | 3 row 2 : Best Song | 5 row 3 : Best Sound Song | 1