1. Get pno and pname values for parts that are priced less than 20.00 and for which orders have been placed.
2. Get all details of customers whose names have the letter e as the second and third letters.
3. Get cname and ename pairs such that the customer with name cname has placed an order through employee with name ename.
4. For each odetail row get ono, pno, pname, qty and price values along with the total price for this item.
5. Get all pairs of cno values for customers living in the same zip code.
6. Get pno values for parts that have been ordered by at least two different customers.
7. Get the cno and cname values for customers who have placed an order for Dirty Harry OR Dr. Zhivago.
8. Get cname values for customers who have placed at least one order with employee with eno = 1000.
9. Get the total quantity of part 10601 that have been ordered.
10. Get the total sales in dollars on all orders.
11. Get the number of cities in which customers are based.
12. Get the pname values of parts that cost more than the average cost of all parts.
13. For each part get pno and pname values along with total sales in dollars.
14. For each part get pno and pname values along with total sales in dollars, but only when the total sales exceeds $1000.
15. Get ono values for orders that were shipped within two days of their receipt.