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,
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.
Step by Step Solution
3.36 Rating (162 Votes )
There are 3 Steps involved in it
a b Product Name Flower Drop Earrings Engagement Ring Diamond Earrings ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
773-B-A-G-F-A (8733).docx
120 KBs Word File
