3059. Find All Unique Email Domains

SQL

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