select `user_name`, substr(`email`, position('@' in `email`) + 1) as `Email Provider` from users
order by `Email Provider`, `user_name`;