Total Students in Sabaragamuwa Province added to the System

[gprasangika]

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

SELECT COUNT(*) as NumberOfStudent from
(SELECT DISTINCT it.institution_id,it.student_id,it.education_grade_id from institution_students it) ist
inner join institutions on ist.institution_id = institutions.id
where area_id in(SELECT id from openemis.areas where areas.parent_id=6)