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.

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

Task 1 sql SELECT BID BNAME DATE FROM BOAT LEFT JOIN RESERVATION ON BOATBID RESERVATIONBID This quer... View the full answer