SELECT Users.Id AS Id, COUNT(Posts.Id) AS NumPosts FROM U...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

SELECT Users.Id AS Id, COUNT(Posts.Id) AS NumPosts
FROM Users
 LEFT JOIN Posts
 ON Users.Id = Posts.OwnerUserId
 GROUP BY Users.Id

Enter Parameters

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