gregy2k

## brentOzar_quizz_20240229.sql

SELECT TOP (10) u.[Location]
	, COUNT(DISTINCT p.OwnerUserId) AS NbUsers
	, COUNT(p.Id) AS NbPosts
	, SUM(Score) AS TotalScore
FROM dbo.Users u
JOIN dbo.Posts p ON p.OwnerUserId = u.Id AND p.PostTypeId = 2 -- Answers
WHERE 1=1
	AND u.[Location] IS NOT NULL AND u.[Location] <> ''
GROUP BY u.[Location]

	SELECT TOP (10) u.[Location]
	, COUNT(DISTINCT p.OwnerUserId) AS NbUsers
	, COUNT(p.Id) AS NbPosts
	, SUM(Score) AS TotalScore
	FROM dbo.Users u
	JOIN dbo.Posts p ON p.OwnerUserId = u.Id AND p.PostTypeId = 2 -- Answers
	WHERE 1=1
	AND u.[Location] IS NOT NULL AND u.[Location] <> ''
	GROUP BY u.[Location]