SELECT COUNT(DISTINCT UserName), VideoTitle 
FROM cs_VideoViewTracking
WHERE DATEPART(YEAR, DateViewed) >= '2006' AND 
       DATEPART(MONTH,DateViewed) >= '06' AND 
       DATEPART(DAY, DateViewed) >= '01') 
GROUP BY VideoTitle