Create select queries for What SUP using specific criteria (use the Ch11-02 student file).
a. Create and print a select query that lists the buyer name, buyer phone number, and product name of product number 234. (The product number should not appear on your printed query if you answered the question correctly.) Save this query as Ch 11 Assignment 1a before you print it.
b. Create and print a select query that lists the category name, product name, product number, and lead times for all products with a lead time in excess of 7 days sorted by product name. Save this query as Ch 11 Assignment 1b before you print it.