BuslerLAB4

BuslerLAB4 - Chelsea Busler IST 210 Lab#4 7/2/11 1. Use the...

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

View Full Document Right Arrow Icon
Chelsea Busler IST 210 Lab#4 7/2/11 1. Use the NULL keyword to display the product_id, for records that have no value for the field end_date from the table demo_price. SELECT product_id , end_date FROM demo_price WHERE end_date IS NULL; product_id end_date --------------------------------------- ----------------------- 100860 NULL 100861 NULL 100870 NULL 100871 NULL 100890 NULL 101860 NULL 101863 NULL 102130 NULL 102132 NULL 102134 NULL 102136 NULL 103120 NULL 103121 NULL 103130 NULL 103131 NULL 103140 NULL 103141 NULL 104350 NULL 104351 NULL 104352 NULL 104360 NULL 104361 NULL 104362 NULL 105123 NULL 105124 NULL 105125 NULL 105126 NULL 105127 NULL 105128 NULL 200376 NULL 200380 NULL (31 row(s) affected) 2. Display the customer_id , name and city for customers located in the state of California and assigned to salesperson 7844. Hint: you will need to determine the code for California. SELECT customer_id , name , city , state FROM demo_customer WHERE salesperson_id = 7844 and state = 'CA'
Background image of page 1

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

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

This note was uploaded on 07/13/2011 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Penn State.

Page1 / 3

BuslerLAB4 - Chelsea Busler IST 210 Lab#4 7/2/11 1. Use the...

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

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