100% Schools from 10167

[gprasangika]

Percentage of schools which have started data entry.

select
(count(id)100)/(SELECT count() from institutions where openemis.institutions.institution_status_id = 1),
$__time(ist.created, '1h')
from institutions ist
where id in (select institution_id from institution_students);

---

Number of active schools.

SELECT count(*) from institutions where openemis.institutions.institution_status_id = 1