All the questions must be solved with multi-table select, joins, and nested queries.

WRITE ALL THREE QUERIES OF EACH QUESTION

Q1. Write a query that will display all the boats and its reservation.

Q2. Write a query that will display all the sailors with their reservations.

Q3. Write a query that will display all the sailors with the boats they booked.

Q4. Write a query that will display all the reservations with sailors' names of those whose reservations are 11-12-2021.

SAILOR SID RESERVATION SID BID BOAT BID ADDRESS 1 1 SNAME 1 UMER 2 AHMED 3 NAEEM 4 ALI ABC ABC BNAME 1 BOATA 2 BOAT-B 3 BOAT-C 2 N XYZ ZYX 1 DATE 1 10/12/2021 2 10/12/2021 1 11/12/2021 1 11/12/2021 2 12/12/2021 1 12/12/2021 12/13/2021 12/13/2021 2 3 3 N 1 1 N