Please only write the queries. Thanks in advance!

1. Write a query to show the detail of the customer with the highest credit limit.
2. Write a query to show the number of payments from each customer. Hint: use a subquery in the SELECT clause.
3. Write a query to show the highest total payment. Hint: use the solution to Q2 in the From Clause.
4. Write a query to show the number of each customer's orders. Hint: use a subquery in the SELECT clause.
5. Write a query to show the customer that has the highest number of orders. Hint: use the solution to Q4 in the From Clause.
6. Write a query to show the number of employees in each office. Hint: use a subquery in the SELECT clause.
7. Write a query to show the customers that have not placed any orders. Hint: use a subquery in the WHERE clause.
8. Write a query to show the value of each order. Hint: use a subquery in the SELECT clause.
9. Write a query to show the total payments of each customer. Hint: use a subquery in the SELECT clause with the slight modification of Q2.
10. Write a query to show the products that have not been ordered. Hint: use a subquery in the WHERE clause.

TABLE LIST customers employees offices orderdetails orders payments productlines products