$10\mathrm{.}8($Compound joins using WHERE$)$ Based on the plumbing supply store database from Chapter $7,$ write SQL queries to perform the following tasks:

Write a query that shows, for each row of the ORDERDETAIL table, the first and last name of the corresponding customer, the date of the order, the quantity ordered, and the name of the product. Use only WHERE conditions to join the tables.

Create a query producing the same output as part $($a$)$ using MS Access Query Design View. Switch to SQL view and compare the contents of the FROM clause to what you wrote in part $($a$).$

Perform the same query as part $($a$),$ using WHERE to join tables, but only include rows for which the quantity ordered is at least $5.$

Repeat the query from part $($a$),$ but showing all rows for which the quantity ordered is at least $5$ or the unit price is over $$1,500.$