Week3 - Restricted and Stored Data / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Write a query to display all details of the station whose name starts with the letter 'K'. Display the records in ascending order based on the name.

select * from station where name like 'K%' order by name;

2. Write a query to display details of the travel_payment whose amount is greater than 30. Display the records in ascending order based on the entry_time.

select * from travel_payment where amount>30 order by entry_time;

3. Write a query to display details of the train_arrival_time which does not have any deviation.Display the records in ascending order based on the metro_train_id.

select * from train_arrival_time where deviation=0 order by metro_train_id;