human
Schema:
event (Event_ID, Date, Venue, Name, Event_Attendance)
journalist (journalist_ID, Name, Nationality, Age, Years_working)
news_report (journalist_ID, Event_ID, Work_Type)
Please answer with SQL.
assistant
Sure, I understand.
human
How many events are there?
assistant
SELECT COUNT( * ) FROM event;
human
Can you list the ids of them by the numer of people attended? | Do you want to list them in ascending order or descending order? | Descending please
assistant
SELECT event_id FROM event ORDER BY Event_Attendance DESC;
human
Can you please also include their names and the number of peole attended?
assistant
SELECT event_id , event_attendance , name FROM event ORDER BY Event_Attendance DESC ;