Central Province Schools Started Data entry

[gprasangika]

Name, Census No, Zone and Number of Students, of Central 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(openemis.institution_students.modified)
FROM openemis.institution_students
) 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=3
WHERE openemis.institutions.institution_status_id = 1
GROUP BY openemis.institution_students.institution_id