Ver originalselect count(*), correo from(select substring(email, INSTR(email,'@')+1, len(email)) as correo from tabla) as t1 group by correo