Create additional select queries for Coast Jewelers using comparison operators. a. Create and print a select query
Question:
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
Question Posted: