Most-listed institutions in a year

Custom SQL query (hide)

select i.name as institution, i.two_year, count(*) as appearances, count(distinct a.person_id) as people
from appearances a join institutions i on i.id = a.institution_id
where a.year = :year
group by i.id order by appearances desc limit 50

Query parameters

year

Edit SQL