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

CASE#1

a)
SELECT DISTINCT		s_class
FROM students
ORDER BY s_class;

b)
SELECT s_first, s_last, s_mi
FROM students
WHERE s_mi is NULL;

c)
SELECT s_first, s_last, TO_CHAR(s_dob, 'MM/DD/YYYY')
FROM students
WHERE s_class IN ('JR', 'SR');

d)
SELECT s_first, s_last, s_dob
FROM students
WHERE s_dob LIKE '%85';

e)
SELECT c_sec_id, sec_num, c_sec_day, TO_CHAR(C_sec_time, 'HH:MI AM')
FROM course_section
WHERE c_sec_day LIKE 'M%';