select count (u.id) from users u join posts p on u.id = p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

select count (u.id) from users u
    join posts p on u.id = p.OwnerUserId and p.PostTypeId = 1
    where u.Reputation > 100 and
    (p.title like '%SQL%' or p.title like '%java%') 
          group by u.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results