Write SQL for each question by using the tables below

CUSTOMERS

OFFICES

ORDERS

PRODUCTS

SALESREPS

1) Show the price in the order, the quantity on hand, and the total quantity for each item where the total quantity in the order is more than 75 percent of the quantity on hand?

2) List salespeople whose quota is less than 10 percent of the company-wide sales target?

3) List the offices where the sales target of the offices exceeds the sum of the salespeople's quotas?

4) List salespeople whose quotas are equal to or higher than the Atlanta sales office's target?

5) List salespeople working in offices above target?

6) List salespeople who do not work in offices run by Larry Fitch (employee 108)?

7) List all customers who ordered from ACI's Widgets (manufacturer ACI, product numbers starting with 4100) between January and June 2008?

8) List products whose order is $25,000 or more?

9) List customers who have not ordered more than $3000 to Sue Smith?

10) List the office where the salesperson works, whose quota represents more than 55 percent of the office

11) List salespeople who have received an order that represents more than 10 percent of the total quota?

12) List the names and ages of salespeople who exceed the average quota?

3) List customers whose sales representatives are assigned to offices in the East sales region?

14) List the manager who manages salespeople who are over 40 and exceed their quota?

15) Find the manufacturer ID and product ID of the product(s) with the highest unit price?

16) List the order numbers and dates of all orders placed for the highest priced item(s)?

17) To the OFFICES table a. add three new offices b. write a query that deletes the last office you added

* (New) * (New)