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

CASE#3

a)
SELECT * 
FROM orders
WHERE (o_date >= TO_DATE('06/01/2006', 'MM/DD/YYYY') AND o_date < TO_DATE('06/11/2006', 'MM/DD/YYYY') ) AND o_methpmt='CC';

b)
SELECT DISTINCT color
FROM inventory
ORDER BY  UPPER(color); 

c)
SELECT ship_id, inv_id, sl_date_received
FROM shipment_line
WHERE ( sl_date_received >= TO_DATE('08/01/2006', 'MM/DD/YYYY')) AND ( sl_date_received <  ADD_MONTHS( TO_DATE('08/01/2006', 'MM/DD/YYYY'), 1 ));

d)
SELECT ABS(  CEIL( sysdate -  ship_date_expected  ) ) AS Difference_in_Days
FROM shipment
WHERE ship_id=1;
  
e)
SELECT *
FROM item
WHERE item_desc LIKE '%Children''s%';