Create additional select queries for Coast Jewelers using wildcards a. Create and print a select query for

Question:

Create additional select queries for Coast Jewelers using wildcards
a. Create and print a select query for Coast Jewelers that lists the product name, quantity, supplier contact name, and supplier phone number for any product name that includes the text "ring". Save this query as Ch 11 Assignment 2a before you print it.
b. Create and print a select query for Coast Jewelers that lists the supplier name, city, and phone number for any supplier located in the city of New York. Save this query as Ch 11 Assignment 2b 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: