Cacher is the code snippet organizer for pro developers

SELECT *
FROM dbo.Assessment a
INNER JOIN dbo.FacilityMaster fm ON a.FacilityId = fm.Id
WHERE a.IsActive = 1
	AND a.FacilityId = 7
	AND a.CompletedDate BETWEEN '2015-11-01 00:00:00.000'
		AND '2016-10-31 23:59:00.000'
-- 4561 + 246 = 4807