select count (t1.c) from (select count (u.id) c from user...

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 (t1.c) from 
(select count (u.id) c 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) t1

Enter Parameters

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