1. List the owner number, last name, and first name of every boat owner. 2. List the...

Question:

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: