Week4 Codes - -- 8 SELECT ISBN, Title, PubID, Cost,Retail,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SPOOL F:\Week4\lab4_FINAL_output.txt SET ECHO ON -- ALIREZA GHOORCHIAN -- WEEK 4 iLAB -- CIS 336 Instructor: Mr. William Leslie -- 1 SELECT category FROM Books group by category; -- 2 SELECT Title,PubID AS Publisher_ID FROM Books; -- 3 SELECT Title,Cost,Retail, Retail - Cost AS Price_Markup FROM Books; -- 4 SELECT FirstName, LastName, City FROM Book_customer WHERE Zip='31206'; -- 5 SELECT Order#,Customer#,OrderDate,ShipDate,ShipStreet,ShipCity,ShipState,ShipZip FROM Book_Order WHERE OrderDate < '02-APR-06'; -- 6 SELECT Order#,Customer#,OrderDate,ShipDate,ShipStreet,ShipCity,ShipState,ShipZip FROM Book_Order WHERE ShipDate IS NULL -- 7 SELECT Customer#,LastName,Address,City,State,Zip, Referred FROM Book_customer WHERE Referred IS NULL AND State = 'FL' OR State = 'NJ';
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -- 8 SELECT ISBN, Title, PubID, Cost,Retail, Category FROM Books WHERE Category <> 'COMPUTER' AND Retail <= 30;-- 9 SELECT AuthorID, Lname, Fname FROM Author WHERE Fname LIKE '%A' ORDER BY Lname DESC;-- 10 SELECT Customer#,OrderDate,ShipDate,ShipStreet,ShipState FROM Book_Order WHERE OrderDate > '01-APR-06' AND OrderDate < '04-APR-06';-- 11 SELECT Order#, Customer#,OrderDate,ShipDate FROM Book_Order WHERE OrderDate BETWEEN '02-APR-06' and '04-APR-06';-- 12 SELECT Title,PubID AS Publisher_ID, PubDate AS Published_Date FROM Books WHERE PubID = 4 AND PubDate > '01-JAN-01';-- 13 SELECT Title,Cost,Retail, ((( Retail - Cost ) / Cost ) * 100) AS Markup FROM Books; SPOOL OFF...
View Full Document

This document was uploaded on 06/24/2011.

Page1 / 2

Week4 Codes - -- 8 SELECT ISBN, Title, PubID, Cost,Retail,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online