(SELECT * FROM cs_VideoViewTracking WHERE
DATEPART(YEAR, DateViewed) >= '2006' AND 
DATEPART(MONTH,DateViewed) >= '06' AND 
DATEPART(DAY, DateViewed) >= '01') AS co2

SELECT COUNT(DISTINCT co2.UserName), co2.VideoTitle FROM co2 GROUP BY co2.VideoTitle