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.