find-all-unique-email-domains.sql

# Time:  O(nlogn)
# Space: O(n)

SELECT SUBSTRING_INDEX(email, '@', -1) AS email_domain,
       COUNT(*) as count
FROM Emails
WHERE email LIKE '%.com'
GROUP BY 1
ORDER BY 1;