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

1)
	a)Read section 13-15

	b)select b.supplier_name,
	              a.description,
	              a.price + nvl(a.price_increase,.10)  as total_price
	   from   l_foods a,
	               l_suppliers b
	   where b.supplier_id=a.supplier_id;

2)
	a)Read section 13-17

	b)select b.description,
                                 sum(quantity) as total_food_items
	    from l_lunch_items a,
                                 l_foods b
	    where a.product_code=b.product_code
	    group by description
	    order by description;

	c)The two tables 'l_lunch_items' and 'l_foods' have no
	   varibles of data type "date" so it is impossible to show
	   the number of servings used in the lunch on November 16, 2005

3)
	a)select a.n
	   from ex1303a a,
	             ex1303b b
	   where a.n=b.n
	   order by a.n;

	b)select a.n
	   from ex1303a a,
	             ex1303c c
	   where a.n=c.n
	   order by a.n;

	c)select a.n
	   from ex1303a a,
	             ex1303b b,
	             ex1303c c
	   where a.n=b.n
                                  and b.n=c.n
	   order by a.n;