gregy2k

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]

gregy2k

WITH QuestionActivity
AS
(
    SELECT
                q.Id                                                AS QuestionId
              , q.CreationDate                                      AS CreationDate
              , DATEPART(dw, q.CreationDate)                        AS DayOfWeekPart
              , DATEPART(HOUR, q.CreationDate)                      AS HourOfDay
              , COUNT(a.Id)                                         AS AnswerCount
              , SUM(CASE WHEN v.VoteTypeId = 2 THEN 1. ELSE 0. END) AS UpvoteCount