At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
select enrol.Rep_Start_Year, uni.university_code, enrol.student_OEN, count(*) as Invalid_OEN_Count from (select enrol.Rep_Start_Year, uni.university_code, enrol.student_OEN, CASE WHEN enrol.student_OEN not in ('999999999','000000000') THEN 'Other' ELSE enrol.student_OEN END as student_OEN from edcs_unistat.ustat_enrolment_data enrol) inner join edcs_unistat.uni_institution_type uniinst on enrol.uni_institution_type_ID = uniinst.uni_institution_type_id inner join (select u.UNIVERSITY_ID, (case when U.UNIVERSITY_CODE = 'DOMC' then 'CARL' when U.UNIVERSITY_CODE = 'NOSM-LAKE' then 'NOSM' when U.UNIVERSITY_CODE = 'NOSM-LAUR' then 'NOSM' when U.UNIVERSITY_CODE = 'LAUR-ALGM' then 'ALGM' when U.UNIVERSITY_CODE = 'LAUR-HRST' then 'HRST' when U.UNIVERSITY_CODE = 'DOMC' then 'CARL' else U.UNIVERSITY_CODE end) as university_code from edcs_core.university u) uni on uniinst.university_id = uni.university_id inner join edcs_unistat.reg_status_type regstatus on enrol.reg_status_type_id = regstatus.reg_status_type_id inner join edcs_unistat.fee_cat_type feetyp on enrol.fee_cat_type_id = feetyp.fee_cat_type_id group by enrol.Rep_Start_Year, uni.university_code, enrol.student_OEN order by enrol.Rep_Start_Year, uni.university_code, enrol.student_OEN
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.