QUERY1

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 COUNT(*),
	MIN(CreationDate) AS min_date,
	MAX(CreationDate) AS max_date,
	AVG(score) as avg_score
FROM posts;


SELECT COUNT(*)
FROM badges
GROUP BY Name
HAVING COUNT(*) > 20;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results