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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select count(distinct u.id)
from users u join posts p on u.id = p.owneruserid
Where 
u.reputation>100 and 
p.posttypeid = 1  and 
p.tags like'%sql%' and 
p.tags like'%java%' or

u.reputation>100 and 
p.posttypeid = 1  and 
p.tags like'%sql%' or 

u.reputation>100 and 
p.posttypeid = 1  and 
p.tags like'%java%'

Enter Parameters

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