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

CASE#5

a)
SELECT DISTINCT c_city
FROM consultant
ORDER BY UPPER(c_city);

b) 
SELECT p_id, project_name, parent_p_id
FROM project
WHERE parent_p_id IS NOT NULL;

c)
SELECT p_id, c_id, extract(day from elapsed_time)   /* "extract" function not in book found on web */
FROM project_consultant
WHERE elapsed_time > TO_DSINTERVAL('30 00:00:00');

d)
SELECT p_id, project_name
FROM project
WHERE (project_name LIKE '%Internet%') OR (project_name LIKE '%Intranet%');