private BlockCompletion[] Completions { get; } = {
            new BlockCompletion("Dim", "dim", BlockCompletionDef.DimStmtCompletionDef, "Dim statement", onlyValidInScope:false),
            new BlockCompletion("Private", "priv", BlockCompletionDef.PrivateStmtCompletionDef, "Private declaration statement", onlyValidInScope:false, validInScope:false),
            new BlockCompletion("Public", "pub", BlockCompletionDef.PublicStmtCompletionDef, "Public declaration statement", onlyValidInScope:false, validInScope:false),

    public static string[] DimStmtCompletionDef =>
        "Dim ${1:identifier} As ${2:Variant}$0".Split('\n');

create table #SurveyValues(
	response nvarchar(50)
	)

insert into #SurveyValues (response)
select distinct OverallExperience
  from SatSurvey
 where OverallExperience is not null

 select *
  from #SurveyValues

Dissatisfied
Very Dissatisfied
Very Satisfied
Satisfied
Neither Satisfied nor Dissatisfied

select OverallExperience, Count(*)
  from #surveyValues SV left outer join SatSurvey SS on SS.OverallExperience = SV.response
 where ss.CollectionDate between '2019/1/1' and '2019/1/3'
group by OverallExperience

Dissatisfied	1
Satisfied	4
Very Dissatisfied	1
Very Satisfied	24