Company: ZS Associates BTSA
Difficulty: medium
Problem Description Write a MySQL query to retrieve the train ID and name of all trains that meet both of the following criteria: The train's name begins with the letter 'M' . The train's destination (i.e., the station it goes to ) is named 'Pune' . Schema Table: train_details_tbl train_id (INT) - Primary Key train_name (VARCHAR(50)) train_type (VARCHAR(5)) - Foreign Key referencing train_type_tbl.train_type train_time (VARCHAR(4)) train_from (VARCHAR(5)) - Foreign Key referencing train_stations_tbl.station_id train_to (VARCHAR(5)) - Foreign Key referencing train_stations_tbl.station_id train_speed (INT) Table: train_type_tbl train_type (VARCHAR(5)) - Primary Key type_description (VARCHAR(30)) Table: train_stations_tbl station_id (VARCHAR(5)) - Primary Key station_name (VARCHAR(30)) Required Output Your query should return exactly 2 columns in the following order: train_id train_name Constraints or Notes The SQL dialect to be used is MySQL . Pay attention to the join relationships: tra