$1$: $(10$ Points$)$ Use the customers' table, and write a query statement to show CustomerName, state, and country columns.

$2$: $(10$ Points$)$ Use the employees table, and write a query statement to show the employee living in the USA.

$3.(10$ Points$)$ Join tables customers, orders, orderdetails and product to show the customer name and the name of products they have ordered.

$4.(10$ Points$)$ Use subquery and find the detail of the most expensive product in the table of products.

$5.(10$ Points$)$ Use the orders & orderdetails tables and find the total order values per customer. Hint: Use group by clause and an aggregation function.

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

$7.(10$ Points$)$ Use the 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