Question: Create additional select queries for Coast Jewelers using comparison operators. a. Create and print a select query for Coast Jewelers that lists the product name,

Create additional select queries for Coast Jewelers using comparison operators.
a. Create and print a select query for Coast Jewelers that lists the product name, unit price, supplier name, and supplier contact name for any unit price between $300 and $600, sorted in descending order by unit price. Save this query as Ch 11 Assignment 4a before you print it.
b. Create and print a select query for Coast Jewelers that lists the product name, unit price, and category name for any unit price less than or equal to $200, sorted in ascending order by unit price. Save this query as Ch 11 Assignment 4b before you print it.

Step by Step Solution

3.54 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b Product Name Diamond Earrings Seiko Kinetic Auto Relay Titanium Sei... 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 (8735).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!