Anonymous

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