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,
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
a b Product Name Diamond Earrings Seiko Kinetic Auto Relay Titanium Sei... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
773-B-A-G-F-A (8735).docx
120 KBs Word File
