Sabaragamuwa Province Schools Started Data entry

[gprasangika]

Name, Census No, Zone and Number of Students, of Sabaragamuwa Province Schools which have started Data entry.

SELECT openemis.institutions.name as School_Name,openemis.institutions.code as Census_No , openemis.areas.name as Zone , FORMAT(COUNT(*),0) as NumberOfStudents
FROM
(SELECT count(ist.modified)
FROM (SELECT DISTINCT it.institution_id,it.student_id,it.education_grade_id,it.modified from institution_students it) ist
) institution_students inner join openemis.institutions inner join openemis.institution_students
on openemis.institution_students.institution_id = openemis.institutions.id
inner join openemis.areas on openemis.institutions.area_id = openemis.areas.id and openemis.areas.parent_id=6
WHERE openemis.institutions.institution_status_id = 1
GROUP BY openemis.institution_students.institution_id