Untitled
public text v1 · immutableSELECT DISTINCT person.username, person.human_name FROM person, role, project_group WHERE
(SELECT COUNT(*) FROM role WHERE role.person_id = person.id AND role.role_status = 'approved') < 3
ORDER BY person.username
SELECT DISTINCT person.username, person.human_name FROM person, role, project_group WHERE
(SELECT COUNT(*) FROM role WHERE role.person_id = person.id AND role.role_status = 'approved') < 3
ORDER BY person.username