SQL Assessments & Investigations

select year(inv_ass_start),count(distinct intake_grouper)
from vw_intakes_screened_in tce
where year(inv_ass_start)>=2006 and 	 (fl_cfws = 1 or fl_frs=1 or fl_risk_only=1 or fl_alternate_intervention=1
			or fl_cps_invs=1 or   tce.fl_dlr=1 or tce.fl_far=1)
	and tce.cd_access_type in (1,2,4)
group by  year(inv_ass_start)
order  by year(inv_ass_start)