1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT CONVERT(date, p.CreationDate,126) as "Date", count(1) AS questions, SUM(p.AnswerCount) as Answers
  FROM posts p
    WHERE p.tags LIKE '%oracle%'
      GROUP BY CONVERT(date, p.CreationDate,126)
        ORDER BY 1 DESC;

fork query

edited oct 2 15

created oct 2 15 gvenzl