0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for amateur radio enthusiasts

select 
users.id, users.displayname,
count(posts.id) as postcount
from users
join posts on users.id=posts.owneruserid
group by users.id,users.displayname

view current version

edited nov 3

created nov 3 jon.doe46178