...
To be executed on the database "managed_idp" on hosted.eduroam.org. The data is cumulative since start of technical setup of the hosts.
SELECT countCOUNT(distinct p.inst_id) AS active_inst, i.country AS federation
FROM silverbullet_user su, LEFT JOIN profile p, institution i
WHERE ON su.deactivationprofile_statusid = "ACTIVE" AND sup.profile_id = LEFT JOIN institution i ON p.inst_id AND= pi.inst_id
=WHERE isu.inst_iddeactivation_status = "ACTIVE"
GROUP BY i.countryfederation
ORDER BY active_inst DESC;
...