Andre Long
CISP 350 Oracle
March 23, 2006
Chapter 3B PSC 

CASE#4

a)
SELECT SUM(inv_qoh)
FROM inventory
WHERE item_id=5;

b)
SELECT COUNT(*)
FROM inventory
WHERE inv_size IS NULL;

c)
SELECT item_id, TO_CHAR( SUM( inv_price * inv_qoh ), '$99,999.99' ) "Inv.Value"
FROM inventory
GROUP BY item_id;

d)
SELECT o_id,  SUM(ol_quantity)
FROM order_line
GROUP BY o_id
HAVING SUM(ol_quantity)>=3;