SQL Assessment

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio Meta

Q&A about the site for amateur radio enthusiasts

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

Enter Parameters

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