CREATE TABLE volume (Volume_ID NUMBER, Volume_Issue CLOB, Issue_Date CLOB, Weeks_on_Top FLOAT, Song CLOB, Artist_ID NUMBER)
CREATE TABLE music_festival (ID NUMBER, Music_Festival CLOB, Date_of_ceremony CLOB, Category CLOB, Volume NUMBER, Result CLOB)
CREATE TABLE artist (Artist_ID NUMBER, Artist CLOB, Age NUMBER, Famous_Title CLOB, Famous_Release_date CLOB)

Show me the total number by category in a histogram
SELECT Category, COUNT(*) FROM music_festival GROUP BY Category
SELECT "Category", COUNT(*) FROM "music_festival" GROUP BY "Category"