Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Vincent Perrin - UNISDR test - Q2
-- Number of posts by location which were written by people who are around 40-50 years old, display locations which have more than 5000 posts
SELECT Users.Location, COUNT(Users.Location) AS post_count
FROM Posts, Users 
WHERE Posts.OwnerUserId = Users.Id
AND Users.Age >= 40
AND Users.Age <= 50
GROUP BY Users.Location
HAVING COUNT(Users.Location) > 5000;

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results