Practice Assignment : Advanced Sailor Queries Sub Queries / Inner Queries

  • Due Apr 17, 2024 by 11:59pm
  • Points 50
  • Submitting a text entry box or a file upload
  • Available Apr 8, 2024 at 12am - Apr 18, 2024 at 11:59pm
This assignment was locked Apr 18, 2024 at 11:59pm.

 

  Download Sailor Query DDL and Data - Summer 2017.sql

 

BoatReservationDatabase Summer 2020.pdf Download BoatReservationDatabase Summer 2020.pdf

 

BoatReservationDatabase Summer 2020 (1).pdf Download BoatReservationDatabase Summer 2020 (1).pdf

 

Examine the tables and data in the attached docu

ment.  Write the queries for the information requested listed in the attached document.  You may do these in groups.

 

I provided a series of videos to follow for this assignment.   If this is an online lecture or for students who may have missed the face to face presentation the video links are at the bottom of the Module on Sub Queries and Inner Queries

 

 

  1. Find the sailor ID  and  names of sailors who have reserved both a red boat or a green boat
    .
  2. Find the Sailor ID  names of sailors who have reserved both a red boat and a green boat.

  3. Find the Sailor ID and names of all sailors who have reserved red boats but not green boats.

 

Submit your queries in a Text File with an SQL Extension

 

 

 

 

1713412799 04/17/2024 11:59pm