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
Which year had the most festivals?
assistant
SELECT year FROM festival_detail GROUP by year ORDER by COUNT( * ) desc LIMIT 1;
human
How many festivals were there in 2008?
assistant
SELECT COUNT( * ) FROM festival_detail GROUP by year having year = 2008;
human
What was the number of the audience for it?
assistant
SELECT num_of_audience FROM festival_detail WHERE year = 2008 ;