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