Analyzing with sql server management studio 20 (ssms) says that the issue is the ending bracket of all the COUNT_BIG with conditions within. Note that the print does not show quotations for dates but ...