はい!今やってます!

Work Pertly, Live Idly

メールアドレスのドメイン毎に件数を集計する

select SUBSTRING(email,LOCATE('@',email)) as domain , count(*) as count from user group by domain;