1. (TCO 6) Write a query to list the product ID, Product name, and the total monetary value of each product (calculated using unitPrice and UnitsInstock) with a heading of Value_Of_Product for each row in the Products table.

2. (TCO 6) Write a query to display all parts that have the word GAS somewhere in the part's description and have between 1 and 10 units on hand.

3. (TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching.

4.

(TCO 7) Using the Doctor_Patient table, write a query to display the Patient ID and the number of treatments for each patient. Show the output as strings like this:

"Patient ID 345 has had 4 treatments"

"Patient ID 567 has had 10 treatments."