SELECT substring_index(EMAIL, '@', -1) domain, COUNT(*) email_count FROM dbcoredigital.tbl_lmb GROUP BY substring_index(EMAIL, '@', -1);