SELECT TOP 10 Location, COUNT(*) AS QuestionCount FROM Us...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
    TOP 10
    Location,
    COUNT(*) AS QuestionCount
FROM Users
JOIN Posts ON Users.Id = Posts.OwnerUserId
WHERE 
    Posts.PostTypeId = 1 -- 1は質問を意味します
    AND Location IS NOT NULL
GROUP BY Location
ORDER BY QuestionCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results