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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment