CREATE TABLE metro(label INT(3), City VARCHAR(20), City_aka VARCHAR(20), Country VARCHAR(20), Continent VARCHAR(20), 
System CHAR(20), Opening DATE, Network_length FLOAT, Stations INT(4), Stations_bis INT(4), Nb_lines INT(3), 
Avg_station_distance INT(5), Avg_line_length FLOAT, Stations_per_line FLOAT, Daily_ridership INT, 
Ridership_per_km INT(6), Annual_ridership INT(5), Ridership_year FLOAT, Fare FLOAT, Tracks CHAR(100), Gauge CHAR(100), 
Power_supply CHAR(100), Voltage CHAR(50), Driverless CHAR(100), Rubber_tyred CHAR(30), Driverless_since YEAR, 
Platform_screen_doors CHAR(100), Aircon_trains CHAR(40), Walk_through CHAR(40), Remarks CHAR(150));