0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for parents, grandparents, nannies and others with a parenting role

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 post_date
FROM Posts
WHERE YEAR(CreationDate) BETWEEN '2013' AND '2014'
GROUP BY MONTH(CreationDate)
ORDER BY MONTH(CreationDate)

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) = '2013'
GROUP BY MONTH(CreationDate)
ORDER BY MONTH(CreationDate)

SELECT COUNT (CreationDate) as number_posts,
    MIN(CreationDate) AS min_date,
	MAX(CreationDate) AS max_date
FROM Posts
WHERE YEAR(CreationDate) = '2014'
GROUP BY MONTH(CreationDate)
ORDER BY MONTH(CreationDate)

fork query

edited sep 28 20

created sep 20 20 anonymous