Write your SQL query statements for each question.

1: Use the customers table, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns.

2: Use the employees table, and write a query statement to show the employees EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if the employee is living in the 98413 zip code.

3. Use INNER JOIN to create a query result. In this query result, list each vendors name and the name of each product the vendor has supplied to our company. You should use the Vendors, Product_Vendors, and the Products tables in the database to complete this task.

4. Use subquery and find the detail of the most expensive product in the table of products.

5. Use the orders table and find the total order values per each customer. Hint: Use group by clause and an aggregation function.

6. Use subquery and show details of the customers that have not placed any orders. If a customer (i.e, its CustomerID) is not in the table of orders, that means the customer has not placed any orders.

7. Use Delete statement to remove products that have not been ordered by any customers. Hint: A product that is not in the table of order_details means the product has not been ordered, find (without duplicate) of those products.

8. Use Update and Case Statements to increase the retail price (under column RetailPrice) of products that are from CategoryID 1 and 2 by 10% and the rest of the products by 5%.