Northern Province Schools not Started Data entry

[gprasangika]

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

SELECT openemis.institutions.name as School_Name, openemis.institutions.code as Census_No, openemis.areas.name as Zone
FROM openemis.institutions
inner join openemis.areas
on openemis.institutions.area_id = openemis.areas.id
where openemis.areas.parent_id=9 && openemis.institutions.id not in (SELECT institution_id from openemis.institution_students) && openemis.institutions.institution_status_id = 1