326 Chapter 4 Homework - Chapter 4 Homework Page 127: 1-20,...

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

View Full Document Right Arrow Icon
Chapter 4 Homework Page 127: 1-20, 22-26, 28-30, 33-38, 41-44 Page 130-131: 1-10 1. SELECT CustNo, CustFirstName, CustLastName, CustBal FROM Customer; 2. SELECT CustNo, CustFirstName, CustLastName, CustBal
Background image of page 1

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

View Full DocumentRight Arrow Icon
FROM Customer WHERE CustState = ‘CO’; 3. SELECT ProdMfg, ProdName, ProdQOH, ProdPrice, ProdNextShipDate, ProdNo FROM Product WHERE ProdPrice > 50.00 ORDER BY ProdNo, ProdName; 4. SELECT OrdNo, OrdDate, OrdName FROM OrderTbl WHERE OrdCity = ‘Denver’ OR OrdCity = ‘Englewood’; 5. SELECT CustNo, CustFirstName, CustLastName, CustBal FROM Customer WHERE (CustCity = ‘Denver’ AND CustBal > 150)
Background image of page 2
OR (CustCity = ‘Seattle’ AND CustBal > 300); 6. SELECT DISTINCT OrdCity, OrdState FROM OrderTbl; 7. SELECT * FROM OrderTbl WHERE EmpNo IS NULL AND OrdDate BETWEEN #1/01/2010# AND #1/31/2010#; 8. SELECT * FROM OrderTbl WHERE EmpNo IS NOT NULL AND OrdDate BETWEEN #2/01/2010# AND #2/28/2010#;
Background image of page 3

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

View Full DocumentRight Arrow Icon
9. SELECT * FROM Product WHERE ProdName LIKE ‘*Ink Jet*’; 10. SELECT OrdNo, OrdDate, CustNo FROM OrderTbl WHERE OrdDate >= #1/23/2010# AND OrdState = ‘WA’; 13. SELECT DISTINCT CustNo.OrderTbl, OrdName, CustBal FROM Customer, OrderTbl WHERE OrdDate BETWEEN #02/01/2010# AND #02/28/2010# AND CustNo.OrderTbl = CustNo.Customer AND OrdState = ‘WA’; 14. SELECT OrdNo, OrdDate, CustNo, OrdName, EmpNo.OrderTbl, EmpFirstName.Employee, EmpLastName.Employee FROM OrderTbl, Employee WHERE OrdDate BETWEEN #01/01/2010# AND #01/31/2010# AND OrdState = CO; 15. SELECT EmpNo, EmpFirstName, EmpLastName, EmpPhone FROM Employee, Customer WHERE OrdDate.Customer BETWEEN #01/01/2010 AND #01/31/2010# AND CustBal.Customer > 300;
Background image of page 4
16. SELECT ProdNo, ProdName, ProdPrice FROM Product, Customer WHERE CustNo = 'C0954327' AND OrdDate BETWEEN #01/01/2010# AND #01/31/2010#;
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/30/2012 for the course CIS 326 taught by Professor Staff during the Spring '08 term at Missouri State University-Springfield.

Page1 / 9

326 Chapter 4 Homework - Chapter 4 Homework Page 127: 1-20,...

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

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