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

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, 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.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: