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

CASE#6

a)
SELECT ROUND( AVG(score), 1)
FROM evaluation
WHERE evaluatee_id=105;

b)
SELECT p_id, c_id,  TRUNC( ( (roll_off_date - roll_on_date)/30.4), 0) AS TOTAL_MONTHS
FROM project_consultant;

c)
SELECT count(*)
FROM consultant_skill
WHERE skill_id=1;