0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT
  YEAR(CreationDate) AS yr,
  COUNT(DISTINCT OwnerUserId) AS uq_owner_count,
  SUM(AnswerCount) AS total_answers,
  SUM(FavoriteCount) AS total_favorites
FROM
  Posts
WHERE
  tags like '%sql%'
GROUP BY
  YEAR(CreationDate)
ORDER BY
  yr DESC

fork query

edited may 11

created may 11 anonymous