Now you have learned query making using SQL in Access. Put yourself in the role of a data analyst and assume that your manager does not know anything about database management, especially the jargons. Your query making results should make sense to your manager. The following problems are based on the Order Entry Database and the three textbook databases: JCC, Pitt Fitness, and Sports Physical Therapy, which you are supposed to be very familiar with. Thus, you know which database you need to use for each of these problems. Write a SQL statement for each problem and then use the SQL view in Access to execute the statement.

Problems:

1. List all columns of the Product table for products costing more than $50. Order the result by product manufacturer (ProdMfg) and product name.
2. 2. List the order number, order date, customer number, and customer name (first and last) of orders placed in January 2017 sent to Colorado recipients.
3. 3. List the average balance and number of customers by city. Only include customers residing in Washington State (WA).Eliminate cities in the result with less than two customers.
4. 4. List the order number, order date, customer number, customer name (first and last), employee number, and employee name (first and last) of January 2017 orders placed by Colorado customers.
5. Get all the Connex-made products with their full information and then put them into a new table called ConnexProducts.
6. Management is thinking about giving a bonus to those employees who were hired on or before 1/1/2020, which is 50 percent of their monthly salary. Make a list showing all these employees with their full names in one column, hire date, and the bonus amount.
7. Find all task records except those with a Per field value of Hour?
8. Find and show all the therapies that have the word bath, hot, or electrical. Add their unit of time in the list, in addition to their code and description.
9. What is the full name of the employee who was assigned to lead the project from SecureCom Wireless?
10. A surcharge is being placed on any patient whose balance is greater than $1,000. That surcharge is 5 percent addition to a patient's current balance. make a update query to perform the calculation.
11. A new patient comes to the Office of Sports Physical Therapy. Suppose you work at the front desk. Ask for his/her information and then add it to the database. The information should be complete, meaning nothing should be missing.
12. Delete the record you added in Problem 11.