Create additional select queries for Coast Jewelers using specific criteria (use the Ch l 1-02 file) a.

Question:

Create additional select queries for Coast Jewelers using specific criteria (use the Ch l 1-02 file)
a. Create and print a select query for Coast Jewelers that lists the buyer name, buyer phone number, and product name of product number ER-800. Save this query as Ch 11 Assignment la before you print it.
b. Create and print a select query for Coast Jewelers that lists the category name, product name, product number, and lead times for all products with a lead time in excess of 20 days. Save this query as Ch 11 Assignment lb before you print it.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: