select goy_id, count(*) as vax_count
from vax_table
group by goy_id
)
select max(vax_count)
from vax_count(http://www.autoadmit.com/thread.php?thread_id=5897982&forum_id=2/en-en/#50097729)