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,

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.

Step by Step Solution

3.36 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b Product Name Flower Drop Earrings Engagement Ring Diamond Earrings ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

773-B-A-G-F-A (8733).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!