SELECT INST.UNIT_ID, 
       INST.INST_FULL_NAME, 
       YR.AWARD_YEAR, 
       AWD.FACULTY_AWARD_CODE, 
       AWD.FACULTY_AWARD_NAME, 
       AWD.FACULTY_AWARD_ORGANIZATION, 
       AWD.FACULTY_AWARD_DESCRIPTION, 
       DTL.NUMBER_OF_AWARDS 
FROM WAREUSER.FACULTY_AWARD AWD, 
     WAREUSER.FACULTY_AWARD_DETAIL DTL, 
     WAREUSER.FACULTY_AWARD_YEAR YR, 
     WAREUSER.INSTITUTION INST 
WHERE YR.FACULTY_AWARD_YEAR_KEY=DTL.FACULTY_AWARD_YEAR_KEY 
AND   AWD.FACULTY_AWARD_KEY=DTL.FACULTY_AWARD_KEY 
AND   INST.INSTITUTION_KEY=DTL.INSTITUTION_KEY
AND   YR.AWARD_YEAR='2004'