human
Schema:
artist (Artist_ID, Artist, Age, Famous_Title, Famous_Release_date)
volume (Volume_ID, Volume_Issue, Issue_Date, Weeks_on_Top, Song, Artist_ID)
music_festival (ID, Music_Festival, Date_of_ceremony, Category, Volume, Result)
Please answer with SQL.
assistant
Sure, I understand.
human
List the information of all music festivals.
assistant
SELECT * FROM music_festival;
human
Only show festivals with category Best Song .
assistant
SELECT * FROM music_festival WHERE Category = 'Best Song';
human
Which of those festivals also have the result Awarded ?
assistant
SELECT * FROM music_festival WHERE Category = "Best Song" AND RESULT = "Awarded" ;