Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT owner,
Count(DISTINCT( breed )) AS num_breeds,
Count(name) AS num_dogs
FROM dogs
GROUP BY owner
ORDER BY num_dogs DESC
LIMIT 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment