Wednesday, February 24, 2010

Before 10:30 AM

select * from sales
select * from slspers
select * from slsperf
select * from titles

select ordnum,qty, partnum, custnum from sales
where qty>(select avg(qty)from sales)

select partnum,devcost, bktitle, slprice, pubdate from titles
where slprice>(select avg(slprice)from titles)


select * from titles
where slprice>(select avg(slprice)from titles)

select * from customers
select custnum from customers
select * from customers where custnum in
(select custnum from sales)

No comments:

Post a Comment