Computer Science > Solutions Guide > Gwinnett Technical CollegeCIST 2161Hands-On Assignments lab9 (All)

Gwinnett Technical CollegeCIST 2161Hands-On Assignments lab9

Document Content and Description Below

Hands-On Assignments 1. Create a list that displays the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. SELECT b.title, p.conta ... ct, p.phone FROM books b, publisher p WHERE b.pubid = p.pubid; SELECT b.title, p.contact, p.phone FROM books b JOIN publisher p USING (pubid); 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order. Sort the results by the date on which the order was placed. SELECT c.firstname, c.lastname, o.order# FROM customers c, orders o WHERE c.customer# = o.customer# AND o.shipdate IS NULL ORDER BY o.orderdate; SELECT c.firstname, c.lastname, o.order# FROM customers c JOIN orders o USING (customer#) WHERE o.shipdate IS NULL ORDER BY o.orderdate; 3. Produce a list of all customers who live in the state of Florida and have ordered books about computers. SELECT DISTINCT c.lastname, c.customer# FROM books b, orders o, orderitems i, customers c WHERE c.customer# = o.customer# AND o.order# = i.order# AND i.isbn = b.isbn AND c.state = 'FL' AND b.category = 'COMPUTER'; SELECT DISTINCT c.lastname, customer# FROM books b JOIN orderitems USING (isbn) JOIN orders USING (order#) JOIN customers c USING (customer#) WHERE c.state = 'FL [Show More]

Last updated: 3 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: