Q&A for professionals, academics, and students working within the systems development life cycle
SELECT COUNT(Id) AS num_posts, MIN(CreationDate) AS min_date, MAX(CreationDate) AS max_date, AVG(score) as avg_score FROM posts; SELECT Name AS name, UserId AS badge_count FROM badges WHERE UserId >= 20; SELECT Id, DisplayName, Location FROM Users Where Location = 'New York, NY'; SELECT COUNT (CreationDate) as number_posts, MIN(CreationDate) AS min_date, MAX(CreationDate) AS max_date FROM Posts WHERE YEAR(CreationDate) BETWEEN '2013' AND '2014' GROUP BY MONTH(CreationDate) ORDER BY MONTH(CreationDate)