(Solution) - Create additional select queries for Coast Jewelers using comparison operators a -(2025 Original AI-Free Solution)

Paper Details

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.