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
State the location of flower awards held?
assistant
SELECT Location FROM festival_detail WHERE Festival_Name = 'Flower Awards';
human
Which festival has the least number of audience?
assistant
SELECT Festival_Name FROM festival_detail ORDER by Num_of_Audience LIMIT 1 ;