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 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