CREATE TABLE train (Train_ID NUMBER, Name CLOB, Time CLOB, Service CLOB)
CREATE TABLE station (Station_ID NUMBER, Name CLOB, Annual_entry_exit FLOAT, Annual_interchanges FLOAT, Total_Passengers FLOAT, Location CLOB, Main_Services CLOB, Number_of_Platforms NUMBER)
CREATE TABLE train_station (Train_ID NUMBER, Station_ID NUMBER)

Draw a scatterplot of sum(number of platforms) vs total number of total passengers where sum(number of platforms) is on the x-axis and points are colored by Location
SELECT SUM(Number_of_Platforms), SUM(Total_Passengers) FROM station GROUP BY Location
SELECT SUM("Number_of_Platforms"), SUM("Total_Passengers") FROM "station" GROUP BY "Location"