HW1 - IS 158 HW #1 3.) SQL> edit Wrote file afiedt.buf 1...

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

View Full Document Right Arrow Icon
IS 158 HW #1 3.) SQL> edit Wrote file afiedt.buf 1 select customer_name 2 from customer 3* where credit_limit <= 10000 SQL> / CUSTOMER_NAME ----------------------------------- Al's Appliance and Sport Brookings Direct Ferguson's The Everything Shop Bargains Galore Johnson's Department Store Lee's Sport and Appliance Deerfield's Four Seasons All Season 9 rows selected.
Background image of page 1

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

View Full DocumentRight Arrow Icon
4.) SQL> edit Wrote file afiedt.buf 1 select order_num 2 from orders 3 where customer_num = 608 4* and order_date = '23-OCT-10' SQL> / ORDER ----- 21617 21623 5.) SQL> select customer_num, customer_name 2 from customer
Background image of page 2
3 where rep_num = 35 or rep_num = 65; CUS CUSTOMER_NAME --- ----------------------------------- 282 Brookings Direct 356 Ferguson's 408 The Everything Shop 462 Bargains Galore 608 Johnson's Department Store 687 Lee's Sport and Appliance 725 Deerfield's Four Seasons 7 rows selected. 6.) SQL> select part_num, description 2 from part 3 where class != 'AP'; PART DESCRIPTION ---- --------------- AT94 Iron BV06 Home Gym
Background image of page 3

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

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

Page1 / 6

HW1 - IS 158 HW #1 3.) SQL&gt; edit Wrote file afiedt.buf 1...

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

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