human
Schema:
festival_detail (Festival_ID, Festival_Name, Chair_Name, Location, Year, Num_of_Audience)
artwork (Artwork_ID, Type, Name)
nomination (Artwork_ID, Festival_ID, Result)
Please answer with SQL.
assistant
Sure, I understand.
human
Show all the names of all the festivals.
assistant
SELECT festival_name FROM festival_detail;
human
Show me the corresponding year for these festivals.
assistant
SELECT festival_name , year FROM festival_detail;
human
What were the amount of festivals for each of these years?
assistant
SELECT year , COUNT( * ) FROM festival_detail GROUP BY Year;
human
Which of these years has more than one festival?
assistant
SELECT YEAR FROM festival_detail GROUP BY YEAR HAVING COUNT( * ) > 1 ;