(IN SQL)

/* 6. Create a list of all the products (prod_id and name) if all the following are true (7 records) Supplierid = 2, 5, 16, 8, or 9 Categoryid = 1, 2, or 4 Unitprice > 15.00 */

/* 7. Create a list of all the products (prod_id and name) if all the following are true (11 records)

Supplierid = 2, 5, 16, 8, or 9 AND Categoryid = 1, 2, or 4 AND Unitprice > 15.00 OR Supplierid = 1, 4, 8 AND categoryid= 3 or 4 */

/* 8. Create a list of product names that have the second letter of the name = h (8 records) */

/* 9. Create a list of product names that have the second letter of the name = a and the last letter = e (2 records) */

/* 10. List all the customers that have one of the following fields NULL (Region or Fax). Also the title of the contact should be Owner Sort the list by contact name (14 records) */

/* 11. List each employees name (first and last in one column) and their birthdate. Sort the list by birthdate. */