Activity: SQL Joins
(no submission)Purpose:
- Be familiar with database queries
- Practice writing and interpreting SQL
- Get ready to work on homework assignment and course project
You may make a copy of a worksheet and complete this activity, or simply type your answers in any text editor.
You may work alone or with 1-2 other students in this course (max size=3).
Import alldbs.sql into your database server (if you have not done so). Write SQL queries to solve the following problems. You will need to consider tables: Boats, Sailors, Reserves.
- Find the names of sailors who have reserved boat 103
- Find the colors of the boats reserved by Guppy.
- Find the names of sailors who have reserved a red boat
- Find the names of the sailors who have not reserved a boat
- Find the sid's of the sailors who have reserved a boat
whose name (the boat's name) begins with the letter "M"
- Find the number of times each sailor (sid) reserved a boat
whose name (the boat's name) begins with the letter "M"
Copyright © 2026 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2026-09-13 19:16