Week3 - Retrieve Data using the SQL SELECT Statements / 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 the person_name and contact_number from the 'travel_card'.Display the records in ascending order based on the person_name.

select person_name,contact_number from travel_card order by person_name;

2. Write a query to display travel_card_id, entry_time and exit_time from the travel_payment.Display the records in ascending order based on the entry_time.

select travel_card_id,entry_time,exit_time from travel_payment order by entry_time;