SELECT Users.Id, COUNT(*) as Num_Questions FROM Users, Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT Users.Id, COUNT(*) as Num_Questions
FROM Users, Posts
WHERE Users.CreationDate > 1/1/2012 AND Users.CreationDate < 6/1/2012 AND Users.Id=Posts.OwnerUserId
GROUP BY Users.Id
ORDER BY Num_Questions

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results