Computer Science > QUESTIONS & ANSWERS > Royal Melbourne Institute of TechnologyIT D132Hands-On Assignments - 9-ALL ANSWERS CORRECT (All)

Royal Melbourne Institute of TechnologyIT D132Hands-On Assignments - 9-ALL ANSWERS CORRECT

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. --Ans:- SELECT titl ... e, contact, phone FROM Books b, Publisher pb WHERE b.pubid = pb.pubid; SELECT title, contact, phone FROM Books b JOIN Publisher pb ON b.pubid = pb.pubid; --Result:- TITLE CONTACT PHONE ------------------------------ --------------- ------------ BODYBUILD IN 10 MINUTES A DAY RENEE SMITH 800-555-9743 REVENGE OF MICKEY TOMMIE SEYMOUR 000-714-8321 BUILDING A CAR WITH TOOTHPICKS JANE TOMLIN 010-410-0010 DATABASE IMPLEMENTATION DAVID DAVIDSON 800-555-1211 COOKING WITH MUSHROOMS RENEE SMITH 800-555-9743 HOLY GRAIL OF ORACLE DAVID DAVIDSON 800-555-1211 HANDCRANKED COMPUTERS DAVID DAVIDSON 800-555-1211 E-BUSINESS THE EASY WAY JANE TOMLIN 010-410-0010 PAINLESS CHILD-REARING SEBASTIAN JONES 800-555-8284 THE WOK WAY TO COOK RENEE SMITH 800-555-9743 BIG BEAR AND LITTLE DOVE SEBASTIAN JONES 800-555-8284 TITLE CONTACT PHONE ------------------------------ --------------- ------------ HOW TO GET FASTER PIZZA RENEE SMITH 800-555-9743 HOW TO MANAGE THE MANAGER TOMMIE SEYMOUR 000-714-8321 SHORTEST POEMS SEBASTIAN JONES 800-555-8284 14 rows selected --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. --Ans:- SELECT Order#, (firstname ||' '|| lastname) name FROM orders o, customers c WHERE o.customer# = c.customer# AND o.shipdate IS NULL; SELECT Order#, (firstname ||' '|| lastname) name FROM orders o JOIN customers c ON o.customer# = c.customer# AND o.shipdate IS NULL; --Result:- ORDER# NAME ---------- --------------------- 1018 BONITA MORALES 1016 LEILA SMITH 1020 KENNETH JONES 1012 BECCA NELSON 1019 GREG MONTIASA 1015 KENNETH FALAH [Show More]

Last updated: 3 years ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: