Andre Long
								CISA 321 (SQL)
								December 8, 2004
								Chapter 11 homework



1)
	a)[Oracle]
	   Read sections 11-3 & 11-5

	b)select min(price) from l_foods;

2)
	a)Read section 11-6

	b)select count(*) from l_lunch_items;

3)
	a)Read section 11-9

	b)select count(  distinct(supplier_id || '*' || product_code) )
	   from l_lunch_items;

4)
	a)Read section 11-10 & 11-11

	b)select sum(nvl(price,0)) + sum(nvl(price_increase,0))
		as columns_added_first,
	             sum(nvl(price,0) + nvl(price_increase,0))
		as rows_added_first
	   from l_foods;