Practice Assignment : Advanced Sailor Queries

  • Due Apr 16, 2018 by 11:59pm
  • Points 100
  • Submitting a text entry box or a file upload
  • Available until Apr 17, 2018 at 11:59pm
This assignment was locked Apr 17, 2018 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.

 

  1. Find the names of sailors who have reserved a red or a green boat
  2. Find the names of sailors who have reserved both a red boat and a green boat.
  3. Find the names and ages of the sailor that reserved boat 3
  4. Find the sids of all sailors who have reserved red boats but not green boats.

 

 

 

 

1523937540 04/16/2018 11:59pm