0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with que as (
select id
from posts
where posttypeid=1 and ((tags like '%sql%java%') or (tags like '%java%sql%'))
),
ans as (
select OwnerUserId, OwnerDisplayName
from posts
join que on que.id=posts.parentid
where posttypeid=2
)
select distinct DisplayName
from users
join ans on DisplayName=OwnerDisplayName
where users.reputation > 100

fork query

created jun 6 22 n1tr0xs