plotkin

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

SELECT question.Id, DATEDIFF(s, answer.CreationDate, question.CreationDate)
FROM Posts question JOIN Posts answer ON question.AcceptedAnswerId = answer.Id
WHERE YEAR(question.CreationDate) = 2017;

SELECT AVG(DATEDIFF(second, DeletionDate, CreationDate))
FROM Posts
WHERE YEAR(CreationDate) = 2017
  AND DeletionDate IS NOT NULL
  AND CreationDate IS NOT NULL;

SELECT TOP 10 Tags, COUNT(*) AS tagCount
FROM Posts
WHERE Tags IS NOT NULL
GROUP BY Tags
ORDER BY COUNT(*) DESC;

SELECT Views, COUNT(*) AS nViews
FROM Users
GROUP BY Views
ORDER BY COUNT(*) DESC;

SELECT COUNT(*)
FROM Posts
WHERE YEAR(CreationDate) = 2017;

Enter Parameters

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