instruction: data explorer query to find winner of (proposed) new contest. https://photo.meta.stackexchange.com/questions/5899/sql-help-wanted-data-explorer-query-to-find-winner-of-proposed-new-contest/5900#5900
response: SELECT p.Id, p.CreationDate, DATEADD(ww, -1, GETDATE()), DATEADD(ww, 0, GETDATE()) FROM Posts AS p INNER JOIN PostTags AS pt ON pt.PostId = p.Id INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName = 'lens'