Aipo のスケジュールを登録件数順にリストアップするSQL

select CONCAT(last_name, first_name), count(*) as c from eip_t_schedule, turbine_user where eip_t_schedule.create_user_id = turbine_user.user_id group by create_user_id order by c desc;