Public feed #601879

Anonymous

public sql v1 · immutable
Raw Edit
·published 2007-07-03 19:38 UTC
rendered paste body
(SELECT * FROM cs_VideoViewTracking WHEREDATEPART(YEAR, DateViewed) >= '2006' AND DATEPART(MONTH,DateViewed) >= '06' AND DATEPART(DAY, DateViewed) >= '01') AS co2SELECT COUNT(DISTINCT co2.UserName), co2.VideoTitle FROM co2 GROUP BY co2.VideoTitle