Back to AssessmentAccenture Coding: SQL Practice

SQL Practice

Relational schema analysis & query formulation

Question 1 of 2

Question 1: Train Speed Filter

Write an SQL query to display the train name and their type which have speed less than 50.

Expected Output Columns

TRAIN_NAME

TRAIN_TYPE

Database Schema Diagram

Database Schema Diagram3 Tables

100%

train_details_tbl[table]

train_id

INT

train_name

VARCHAR(50)

FKtrain_type

VARCHAR(5)

train_time

VARCHAR(4)

FKtrain_from

VARCHAR(5)

FKtrain_to

VARCHAR(5)

train_speed

INT

train_type_tbl[table]

train_type

VARCHAR(5)

type_description

VARCHAR(30)

train_stations_tbl[table]

station_id

VARCHAR(5)

station_name

VARCHAR(30)