0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT 
    Tags.TagName as Region,
    COUNT(DISTINCT Posts.Id) as QuestionCount,
    AVG(CAST(Posts.Score as FLOAT)) as AvgScore,
    SUM(Posts.ViewCount) as TotalViews,
    COUNT(DISTINCT Posts.AcceptedAnswerId) as AcceptedAnswers,
    AVG(CAST(Posts.ViewCount as FLOAT)) as AvgViews
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE Tags.TagName IN ('india', 'china', 'japan', 'southeast-asia', 'europe', 'usa', 
    'south-america', 'middle-east', 'africa', 'australia')
    AND Posts.PostTypeId = 1
GROUP BY Tags.TagName
ORDER BY QuestionCount DESC;

fork query

edited dec 6

created dec 6 anonymous