query.sql

select master_districts.state as state,
COUNT(*) as num_s2_respondents
from enrollments,
cohorts,
schools,
response_sets,
master_schools,
master_districts
where cohorts.curriculum_id = 5
and cohorts.school_id = schools.id
and enrollments.cohort_id = cohorts.id
and enrollments.user_id = response_sets.user_id
and response_sets.survey_id = 13
and schools.master_school_id = master_schools.id
and master_schools.master_district_id = master_districts.id
group by master_districts.state
--response_sets.survey_id
having COUNT(*) >= 50
order by 1,2