Someone
public text v1 · immutableselect distinct P.name, COUNT(R.role) as num
from people P, role R
where P.person_id = R.person_id
and R.role = 'actor'
and num > 2
group by R.person_id;select distinct P.name, COUNT(R.role) as num
from people P, role R
where P.person_id = R.person_id
and R.role = 'actor'
and num > 2
group by R.person_id;