JiyuSong 3-13 InClassActivity

JiyuSong 3-13 InClassActivity - where (shippostalcode =...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1. select orderid, customerid, freight from Northwinds.orders where freight between 600 and 700 2. select orderid,customerid, shippeddate from northwinds.orders where shippostalcode = '5020' or shippostalcode='5022' order by customerid, shippeddate 3. select shippostalcode, count(orderid) from northwinds.orders where shippostalcode = '5020' or shippostalcode='5022' group by shippostalcode; 4. select orderid, customerid, employeeid, shippeddate, shipcity, shipcountry from northwinds.orders
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: where (shippostalcode = '5020' or shippostalcode='5022') and employeeid =4 order by shippeddate desc 5. select companyname, lastname,firstname, shippeddate, shipcity, shipcountry from northwinds.orders, northwinds.employees, northwinds.customers where orders.customerid=customers.customerid and orders.employeeid=employees.employeeid and (shippostalcode = '5020' or shippostalcode='5022') and orders.employeeid ='4' order by shippeddate desc...
View Full Document

Ask a homework question - tutors are online