Something

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