Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence
SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(CreationDate) AS max_date, AVG(score) AS avg_num_posts FROM posts SELECT name AS name, COUNT(name) AS badge_count FROM badges GROUP BY name HAVING COUNT(name)>20 SELECT Id, displayname, location FROM users SELECT month(creationdate) FROM posts