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

CASE#2

a)
SELECT *
FROM enrollment
WHERE (grade IS NOT NULL) AND (grade <> 'C');

b)
SELECT s_id "Student ID", TRUNC( (sysdate - s_dob) / 365.25 )"Student Age"
FROM student
WHERE (s_last='Connoly') AND (s_first='Michael');

c)
SELECT c_sec_id, sec_num, c_sec_day, LTRIM( ( TO_CHAR( c_sec_time, 'HH:MI AM' )), '0')
FROM course_section;

d)
SELECT COUNT(grade)
FROM enrollment
WHERE grade='B';

e)
SELECT AVG(max_enrl)
FROM course_section
WHERE (course_id=1) AND (term_id=4);