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)
CREATE TABLE volume (volume_id NUMBER, volume_issue CLOB, issue_date CLOB, weeks_on_top NUMBER, song CLOB, artist_id NUMBER)

How many music festivals have had each kind of result, ordered descending by count?
SELECT result, COUNT(*) FROM music_festival GROUP BY result ORDER BY COUNT(*) DESC
SELECT "result", COUNT(*) FROM "music_festival" GROUP BY "result" ORDER BY COUNT(*) DESC