0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

select top 10 displayname
from posts q join posts a on q.id = a.parentid
join users u on a.owneruserid = u.id
where --можно и убрать при желании(q.tags like '%<sql>%' or q.tags like '%<java>%') and 
u.reputation > 100
group by u.id, u.displayname
having count(case when q.tags like '%<sql>%' then 1 end) > 0 and
count (case when q.tags like '%<java>%' then 1 end) > 0

fork query

edited nov 17 17

created nov 16 17 anonymous