Something

SELECT events.event_id, count(event_response_id) FROM `events`  left join event_responses on events.event_id = event_responses.event_id where events.active_ind = 'Y' order by count(event_response_id)group by event_idlimit 100