Write SQL for each question by using the tables below .

CUSTOMERS TABLE

OFFICES

ORDERS

PRODUCTS

SALESREPS

1) List the names of the sales offices, their targets and their actual sales?

2) List the East region sales offices and their targets and sales?

3) List the East region offices whose sales exceeded their targets, in alphabetical order by city name?

4) List all salespeople's names, offices, and dates of hire?

5) What is the name, quota and sales amount of employee number 107?

6) What is the average of the sales amounts of all salespeople?

7) List the names and hiring dates of salespeople with sales over $500000?

8) List salespeople, quotas and managers?

9) List the location, region and sales of each sales office? CALCULATED FIELD

10) List the city, region and amount above/below the target for each office. (Calculation required) 11) Show stock value (holding cost) for each product. (Price transaction with stock quantity)

12) If I increased each salesperson's quota by 3 percent of their annual sales, what would their new quota be?

13) List the sales amounts for each city?

14) List all sales office managers with their employee numbers?

15) List the offices whose sales are above their targets?

* (New)