human
Schema:
station (Station_ID, Name, Annual_entry_exit, Annual_interchanges, Total_Passengers, Location, Main_Services, Number_of_Platforms)
train (Train_ID, Name, Time, Service)
train_station (Train_ID, Station_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the top three total number of passengers?
assistant
SELECT total_passengers FROM station ORDER BY total_passengers DESC LIMIT 3;
human
What are the names and main services for train stations for these?
assistant
SELECT name , main_services FROM station ORDER BY total_passengers DESC LIMIT 3 ;