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 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)

A bar chart for what are the number of the category of music festivals with result 'Awarded'?, and I want to order by the X-axis from high to low.
SELECT Category, COUNT(Category) FROM music_festival WHERE Result = "Awarded" GROUP BY Category ORDER BY Category DESC
SELECT "Category", COUNT("Category") FROM "music_festival" WHERE "Awarded" = "Result" GROUP BY "Category" ORDER BY "Category" DESC