Difference: CSC210S2024Home1 ( vs. 1)

Revision 12024-01-08 - CathyBareiss

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="CSC210SylS2024"

SQL Homework 1

This homework uses the sailors data

Only turn in the sql statements (not the results of the query). You may test your queries out online. (But remember, just because you get the right data back, that does not mean your query is correct!). Turn in an electronic copy of your .sql file. Be sure to include your name and label each question (using comments).

Questions:
  1. Find the ids of the sailors who have reserved boat number 103.
  2. What is the color of the clipper boat?
  3. What are the different ratings of people in their 30's?
  4. What are the different colors of the boats (don't list duplicate colors)?
  5. What sailor names are three letters long?
  6. Find the ages of sailors whose name begins and ends with B and has at least three characters.
View topic | History: r1 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback