Write SQL for each question by using the tables below .

CUSTOMERS TABLE

OFFICES

ORDERS

PRODUCTS

SALESREPS

1- How many salespeople exceeded their quota? 2- How many orders are over $25,000? 3- Find the average order amount, the total order amount, the average order amount as a percentage of the customer's credit limit and the average order amount as a percentage of the sales representative's quota? 4- What is the quota range assigned in each office? (Max - min according to sales personnel) 5- How many salespeople work in each office? 6- How many different customers are served by each salesperson? 7- List the total order amount for each customer of each salesperson? 8- Calculate the total order of each salesperson? 9- What is the average order size for each salesperson with orders totaling more than $30000? 10- For each office consisting of two or more people, calculate the total quota and total sales of all salespeople working in the office?

* (New)