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
What festivals are there?
assistant
SELECT festival_name FROM festival_detail;
human
What is the audience size for each of these festivals?
assistant
SELECT festival_name , num_of_audience FROM festival_detail;
human
Which of these festivals has the largest audience?
assistant
SELECT festival_name FROM festival_detail WHERE num_of_audience = ( SELECT MAX( num_of_audience ) FROM festival_detail ) ;