Company: ZS_4oct
Difficulty: medium
Problem Description Write an SQL query to retrieve the train IDs and names of all trains that have a scheduled speed 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