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
Show locations for stations.
assistant
SELECT LOCATION FROM station;
human
Show locations for stations with at least 15 platforms.
assistant
SELECT LOCATION FROM station WHERE number_of_platforms >= 15;
human
Among those, which locations also have stations with more than 25 total passengers?
assistant
SELECT LOCATION FROM station WHERE number_of_platforms >= 15 AND total_passengers > 25 ;