Activity: SQL Join
(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 3-4 other students in this course.
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 © 2023 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2023-09-24 20:03