HW5 - IS 158 HW #5 12.) SQL> select part_num, description,...

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

View Full Document Right Arrow Icon
IS 158 HW #5 12.) SQL> select part_num, description, class 2 from part 3 order by class; PART DESCRIPTION CL ---- --------------- -- CD52 Microwave Oven AP DR93 Gas Range AP KL62 Dryer AP KT03 Dishwasher AP DW11 Washer AP AT94 Iron HW FD21 Stand Mixer HW
Background image of page 1

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

View Full DocumentRight Arrow Icon
DL71 Cordless Drill HW BV06 Home Gym SG KV29 Treadmill SG 10 rows selected. 13.) SQL> edit Wrote file afiedt.buf 1 select order_num, order_date 2 from customer, orders 3 where orders.customer_num=customer.customer_num 4* and customer_name='Johnson''s Department Store' SQL> /
Background image of page 2
ORDER ORDER_DAT ----- --------- 21617 23-OCT-10 21623 23-OCT-10 16.) SQL> edit Wrote file afiedt.buf 1 select orders.order_num, order_date 2 from customer, orders, order_line, part 3 where orders.customer_num=customer.customer_num 4 and orders.order_num=order_line.order_num 5 and order_line.part_num=part.part_num 6 and customer_name='Johnson''s Department Store' 7* and description='Gas Range'
Background image of page 3

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

View Full DocumentRight Arrow Icon
SQL> / no rows selected 18.) SQL> edit Wrote file afiedt.buf 1 select part_num, description, price, class 2 from part 3 where price > all 4 (select price 5 from part 6* where class='AP') SQL> /
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/03/2009 for the course INFORMATIO IS 158 taught by Professor Dr.moffitt during the Spring '09 term at CSU Fresno.

Page1 / 8

HW5 - IS 158 HW #5 12.) SQL> select part_num, description,...

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

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