i try to make code like sql to count pass & fail students and the failed one unint, two unit,..
this code to count failed three unit students. in sql server.
SELECT
distinct ACADEMIC.PEOPLE_Id, academic.degree, count(td.EVENT_ID) "fail"
FROM
ACADEMIC
left outer join transcriptdetail td on academic.people_id=td.people_id andacademic.academic_term=td.academic_term and academic.academic_year=td.academic_year
left outer join gradevalues on td.final_grade=gradevalues.grade andtd.academic_year=gradevalues.academic_year and td.academic_term=gradevalues.academic_term andtd.credit_type=gradevalues.credit_type
WHERE
academic.people_ID not in (001211102, 001210796, 001210830, 001311424, 001311428, 001311435, 001311478,001312617, 001313092)
AND ACADEMIC.ACADEMIC_YEAR =2015 and academic.status!='n'
and not(academic.academic_Session='' or academic.academic_Session='easa')
AND ACADEMIC.ACADEMIC_TERM = 'FEB'
and academic.curriculum not like 'eas%' and pass_fail='f' and enroll_separation='en' and primary_flag='y'
and add_drop_wait='a' -- and academic.degree like 'bus%'
AND ACADEMIC.PEOPLE_ID=001210007
group by academic.degree, ACADEMIC.PEOPLE_ID having COUNT(event_id)=3
