select e.enrolled_id, e.user_id count(*) as cnt from enrolleds e inner join enrolleds_derail ed on e.enrolled_id = ed.enrolled_id where ed.done = 1 group by e. enrolled_id, e.user_id order by cnt desc