Create select queries for What SUP using comparison operators. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)
a. Create and print a select query that lists the product name, unit cost, supplier name, and supplier contact name for any unit cost between $100 and $400, sorted in descending order by unit cost. Save this query as Ch 11 Assignment 4a before you print it.
b. Create and print a select query that lists the product name, unit cost, and category name for any unit cost less than or equal to $500, sorted in ascending order by unit cost. Save this query as Ch 11 Assignment 4b before you print it.