SELECT 
AL2.INST_NAME, 
AL6.CIP_PROGRAM_CODE, 
AL6.CIP_PROGRAM_TITLE, 
AL6.CIP_CATEGORY_CODE, 
AL6.CIP_CATEGORY_TITLE, 
AL6.CIP_FOUR_DIGIT_CODE, 
AL6.CIP_FOUR_DIGIT_TITLE, 
AL4.AWARD_LEVEL, 
AL4.AWARD_LEVEL_DEFINITION, 
AL5.GENDER, 
AL5.ETHNICITY, 
AL3.NUMBER_OF_COMPLETIONS 
FROM WAREUSER.ACADEMIC_YEAR AL1, 
     WAREUSER.INSTITUTION AL2, 
     WAREUSER.IPEDS_COMPLETION_DETAIL AL3, 
     WAREUSER.IPEDS_AWARD_LEVEL AL4, 
     WAREUSER.IPEDS_DEMOGRAPHIC AL5, 
     WAREUSER.CIP AL6 
WHERE 
(AL6.CIP_KEY=AL3.CIP_KEY 
 AND AL3.ACADEMIC_YEAR_KEY=AL1.ACADEMIC_YEAR_KEY 
 AND AL2.INSTITUTION_KEY=AL3.INSTITUTION_KEY 
 AND AL4.IPEDS_AWARD_LEVEL_KEY=AL3.IPEDS_AWARD_LEVEL_KEY 
 AND AL3.IPEDS_DEMOGRAPHIC_KEY=AL5.IPEDS_DEMOGRAPHIC_KEY)  
AND 
(AL1.ACADEMIC_YEAR='1999-2000' 
 AND AL2.INST_NAME='MIT' 
 AND AL6.CIP_CATEGORY_TITLE IN ('MATHEMATICS', 'MATHEMATICS AND STATISTICS') 
 AND AL4.AWARD_LEVEL_DEFINITION IN ('Bachelor''s Degrees', 
                                   'Doctor''s Degrees', 
                                   'Master''s Degrees')
)