3. Write a query using the implicit join syntax (the WHERE clause) to display the office id, office city, sales rep name, and quota for all sales reps with a quota that has not been met yet

4. Write the same join statement as number 3 except use the USING syntax and show all reps who have met their quota.

5. Write a query to display the sales rep name, order id, order date, order quantity, product description for any type of Pump. Be sure you look at the data to determine how to write the WHERE clause. Use the implicit Join syntax.

6. Write a query using the explicit join syntax that displays the Office ID, city, and Product descriptions of products that are sold by sales reps under that office. Just display those three columns.

Offices SalesReps OfficelD PK RepiD City Name Region Hire Date MgrD Quota Target Sa les Sales FK OfficelD Customers Orders CustID Products Ordid Company PK ProductiD Phone CustiD Description OrderDate CreditLimit ProductPrice ProductiD Cust ReplD Quantity On Hand ReplD QTY TotalAmt