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
Find the total passengers of London Waterloo?
assistant
SELECT total_passengers FROM station WHERE name = 'London Waterloo';
human
How many Number of Platforms in station id 2?
assistant
SELECT number_of_platforms FROM station WHERE station_id = 2;
human
What are the Main Services of station id 3?
assistant
SELECT main_services FROM station WHERE station_id = 3;
human
Show all locations which don't have a train station with at least 15 platforms.
assistant
SELECT LOCATION FROM station EXCEPT SELECT LOCATION FROM station WHERE number_of_platforms > = 15 ;