Practice Assignment : Advanced Sailor Queries Sub Queries / Inner Queries

  • Due Dec 4, 2023 by 11:59pm
  • Points 50
  • Submitting a text entry box or a file upload
  • Available Nov 27, 2023 at 12am - Dec 5, 2023 at 11:59pm
This assignment was locked Dec 5, 2023 at 11:59pm.

 

  Download Sailor Query DDL and Data - Summer 2017.sql

 

Examine the tables and data in the attached document.  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

 

 

 

 

1701752399 12/04/2023 11:59pm