Database Reference
In-Depth Information
5. List the title of each book that has the type PSY or whose publisher code is JP.
6. List the title of each book that has the type CMP, HIS, or SCI.
7. How many books have a publisher code of ST or VB?
8. List the title of each book written by Dick Francis.
9. List the title of each book that has the type FIC and that was written by John Steinbeck.
10. For each book with coauthors, list the title, publisher code, type, and author names (in the order listed on the
cover).
11. How many book copies have a price that is greater than $20 but less than $25?
12. List the branch number, copy number, quality, and price for each copy of The Stranger.
13. List the branch name, copy number, quality, and price for each copy of Electric Light.
14. For each book copy with a price greater than $25, list the book's title, quality, and price.
15. For each book copy available at the Henry on the Hill branch whose quality is excellent, list the topic's title and
author names (in the order listed on the cover).
30
Alexamara Marina Group Case
Answer each of the following questions using the Alexamara Marina Group data shown in Figures 1-20 through 1-24.
No computer work is required.
1. List the owner number, last name, and first name of every boat owner.
2. List the names of all boats that are stored in a slip with a length of less than 30 feet.
3. List the last name, first name, and street address of every owner located in Glander Bay.
4. List the last name, first name, and city of every owner who has more than one boat stored at the marina.
5. List the last name, first name, and city of every owner with a boat located in a slip whose rental fee is greater
than $2,500.
6. List the boat name and boat type of all boats that are stored at the Alexamara East marina.
7. List the last name and first name of the owner and the boat name of all boats that have a completed or open
service request.
8. List the boat name and boat type of all boats that have two or more completed or open service requests.
9. List the boat name and boat type of all boats that have a completed or open service request for a fiberglass or
canvas-related service.
10. List the boat name and the last and first names of the owners for all boats that have engine repair service
requests.
