Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I'm sorry for not answering before, you can check if this is what you're looking for, please.
Regards.
maverjannet can you help me please with this?
Regards.
Hi,
I'm sorry for not answering before, you can check if this is what you're looking for, please.
Regards.
It's ok, i will check it. Thanks a lot
Regard.