1. select odetails.pno,pname, price from odetails natural join parts where price
< 20;

2. select * from customers where cname like "_ee%";

3. select distinct cname,ename from customers natural join orders natural join
employees;

4. select ono,odetails.pno,pname,qty,price, qty*price from odetails natural join
parts;

5. select t1.cno, t2.cno from customers as t1 inner join customers as t2 using
(zip) where t1.cno <> t2.cno;

6. select pno,count(cno) from odetails natural join orders group by pno having
count(cno) >= 2;

7. select distinct customers.cno,cname from customers natural join orders
natural join odetails natural join parts where pname="Dirty Harry" OR pname = "Dr. Zhivago";

8. select distinct cname from customers natural join orders where eno = 1000;

9. select pno,sum(qty) from odetails where pno = 10601 group by pno;


10. select orders.ono, sum(price*qty) from orders natural join odetails natural
join parts group by orders.ono;

11. select count(distinct city) from customers natural join zipcodes;

12.  select parts.pname, parts.price from parts,parts as q group by parts.pno having parts.price > avg(q.price);

13. select parts.pno, pname , sum(price*qty) as sales from parts natural left outer join odetails group by parts.pno;

14. select parts.pno, pname , sum(price*qty) as sales from parts natural left
outer join odetails group by parts.pno having sales > 40;

15. select distinct orders.ono from orders natural join odetails where shipped - received <= 2;