Company: ZS_4oct
Difficulty: medium
Problem Description Write an SQL query that finds the train IDs and names of every train whose scheduled speed is strictly greater than 75. Schema The database consists of the following tables: Table: train_details_tbl train_id (INT): The unique identifier for the train. train_name (VARCHAR(50)): The name of the train. train_type (VARCHAR(5)): The type code of the train. train_time (VARCHAR(4)): The scheduled time of the train. train_from (VARCHAR(5)): The ID of the departure station. train_to (VARCHAR(5)): The ID of the arrival station. train_speed (INT): The speed of the train. Table: train_type_tbl train_type (VARCHAR(5)): The type code of the train. type_description (VARCHAR(30)): The description of the train type. Table: train_stations_tbl station_id (VARCHAR(5)): The unique identifier for the station. station_name (VARCHAR(30)): The name of the station. Required Output Your query should return the following columns in exactly this order: ID : The ID of the train (aliased from tra