select count(p.id) ,displayname ,u.id from posts p inner ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

select count(p.id)
      ,displayname
      ,u.id
  from posts p
       inner join users u
               on p.owneruserid = u.id
group by displayname, u.id

Enter Parameters

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