Week5 - Views / Assess

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

1. Create a view named 'travel_payment_details' to display the details of the travel_payment whose amount is greater than 30.

    create view travel_payment_details as
    select * 
    from travel_payment 
    where amount>30

2. Create a view named 'train_details_with_deviation' to display the metro train id,position and updated time of all the trains having deviation.

    create view train_details_with_deviation as
    select id,position,updated_time 
    from metro_train 
    where id in (
      select metro_train_id 
      from train_arrival_time 
      where deviation !=0);