select OverallExperience, count(*)
  from SatSurveyAnswers ssa
		left outer join SatSurvey ss on ssa.Answer = ss.OverallExperience
									and ss.CollectionDate between '2019-1-1' and '2019-1-3'
group by OverallExperience

NULL	1
Dissatisfied	1
Satisfied	4
Very Dissatisfied	1
Very Satisfied	24

select CollectionDate, OverallExperience, count(*)
  from SatSurvey
 where CollectionDate between '2019-1-1' and '2019-1-3'
group by CollectionDate, OverallExperience

2019-01-01 00:00:00.000	Very Satisfied	1
2019-01-02 00:00:00.000	NULL	31
2019-01-02 00:00:00.000	Satisfied	2
2019-01-02 00:00:00.000	Very Dissatisfied	1
2019-01-02 00:00:00.000	Very Satisfied	10
2019-01-03 00:00:00.000	NULL	21
2019-01-03 00:00:00.000	Dissatisfied	1
2019-01-03 00:00:00.000	Satisfied	2
2019-01-03 00:00:00.000	Very Satisfied	13

select ssa.Answer, count(*)
  from SatSurveyAnswers ssa
		left outer join SatSurvey ss on ssa.Answer = ss.OverallExperience
									and ss.CollectionDate between '2019-1-1' and '2019-1-3'
group by ssa.Answer

Dissatisfied	1
Neither Satisfied nor Dissatisfied	1
Satisfied	4
Very Dissatisfied	1
Very Satisfied	24

select *
  from SatSurvey
 where CollectionDate between '2019-1-1' and '2019-1-3'
   and OverallExperience like 'Neither%'

select ssa.Answer, count(*)
  from SatSurveyAnswers ssa
		left outer join SatSurvey ss on ssa.Answer = ss.OverallExperience
		and ss.CollectionDate between '2019-1-1' and '2019-1-3'
		and ss.OverallExperience is not null
group by ssa.Answer

Dissatisfied	1
Neither Satisfied nor Dissatisfied	1
Satisfied	4
Very Dissatisfied	1
Very Satisfied	24

select *
  from SatSurvey
 where CollectionDate between '2019-1-1' and '2019-1-3'
   and OverallExperience like 'Neither%'

select ssa.Answer, count(ss.OverallExperience)
  from SatSurveyAnswers ssa
		left outer join SatSurvey ss on ssa.Answer = ss.OverallExperience
		and ss.CollectionDate between '2019-1-1' and '2019-1-3'
		and ss.OverallExperience is not null
group by ssa.Answer

SELECT
  ssa.Answer,
  COUNT(ss.OverallExperience)
FROM dbo.SatSurveyAnswers AS ssa
LEFT JOIN dbo.SatSurvey AS ss
  ON  ssa.Answer = ss.OverallExperience
  AND ss.CollectionDate BETWEEN '2019-1-1' AND '2019-1-3'
  AND ss.OverallExperience IS NOT NULL
GROUP BY
  ssa.Answer
;

select ssa.Answer, count(ss.OverallExperience)
  from SatSurveyAnswers ssa
	left outer join SatSurvey ss on ssa.Answer = ss.OverallExperience
		and ss.CollectionDate between '2019-1-1' and '2019-1-31'
		and ss.OverallExperience is not null
	inner join ClinicConfig CC ON SS.ClinicID = cc.ClinicID
		and (CC.LocationID LIKE 'WPCARM%'
			OR CC.SystocName like 'WPCARM%'
			)
group by ssa.Answer

select distinct OverallExperience
  from SatSurvey ss
	join ClinicConfig CC ON SS.ClinicID = cc.ClinicID
		and (CC.LocationID LIKE 'WPCARM%'
			OR CC.SystocName like 'WPCARM%'
			)
		and CollectionDate between '2019-1-1' and '2019-1-31'

WITH FilteredData AS (
  SELECT
    ss.OverallExperience
  FROM dbo.SatSurvey AS ss
  INNER JOIN dbo.ClinicConfig AS cc
    ON ss.ClinicID = cc.ClinicID
  WHERE ss.CollectionDate BETWEEN '2019-1-1' AND '2019-1-31'
    AND ss.OverallExperience IS NOT NULL
    AND (
      cc.LocationID LIKE 'WPCARM%'
      OR cc.SystocName LIKE 'WPCARM%'
    )
)
SELECT
  ssa.Answer,
  COUNT(fd.OverallExperience)
FROM dbo.SatSurveyAnswers AS ssa
LEFT JOIN FilteredData AS fd
  ON ssa.Answer = fd.OverallExperience
GROUP BY

public static void Run()
{
    var types = AppDomain.CurrentDomain.GetAssemblies().SelectMany(a => a.GetTypes()).ToList();
    RegisterFieldConverters(types, typeof(IConvertedField<>));
    RegisterConverters(types);
}