Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT pp.name AS place_name, COUNT(*) AS attendee_count
FROM attendees AS a
INNER JOIN public_places AS pp
ON CONTAINS(pp.border, a.loc)
GROUP BY pp.name
ORDER BY attendee_count DESC
LIMIT 3
place_name attendee_count
------------------- --------------
TD Banknorth Garden 786
Fenway Park 512
Agganis Arena 413
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.