Total Students in Southern Province added to the System

[gprasangika]

Total number of Students in Southern Province, which has been added to the System.

SELECT COUNT(*) as NumberOfStudent from openemis.institution_students
inner join institutions on institution_students.institution_id = institutions.id
where area_id in(SELECT id from openemis.areas where areas.parent_id=4)