$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.

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.$