Top SO users from China

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT TOP 100 USERS.ID, USERS.DISPLAYNAME, COUNT(POSTS.ID) 
, POSTS.POSTTYPEID
FROM USERS 
LEFT JOIN POSTS ON USERS.ID = POSTS.OWNERUSERID 
-- WHERE POSTS.POSTTYPEID = 1
GROUP BY USERS.ID, USERS.DISPLAYNAME, POSTS.POSTTYPEID 
-- HAVING COUNT(POSTS.ID) = 0

Enter Parameters

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