SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

SELECT
  min(ViewCount),
  max(ViewCount),
  min(ClosedDate),
  max(ClosedDate),
  count(*)
FROM 
  Posts
WHERE
  lower(Tags) like '%sql%'
AND 
  AnswerCount > 0
AND 
  ViewCount > 49
AND 
  ClosedDate is not null

Enter Parameters

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