First questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT CAST(firstasked AS DATE) as askeddate, 
       CASE WHEN COUNT(*) = 0 OR COUNT(*) = NULL
         THEN 0.01
         ELSE COUNT(*)
       END as [FQ per day]
FROM (
  SELECT MIN(CreationDate) as firstasked
  FROM posts as questions
  where questions.PostTypeId = 1
  GROUP BY OwnerUserId) as firstquestions
GROUP BY CAST(firstasked AS DATE)
ORDER BY CAST(firstasked AS DATE)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results