SELECT cast(ClosedDate as date), count(*) FROM Posts WHER...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

SELECT
  cast(ClosedDate as date),
  count(*)
FROM 
  Posts
WHERE
  lower(Tags) like '%sql%'
AND 
  AnswerCount > 0
AND 
  ViewCount > 44
AND 
  ClosedDate is not null
GROUP BY cast(ClosedDate as date)
ORDER BY cast(ClosedDate as date) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results