Third

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select t.tagname
from posts p
join users u on u.id = p.owneruserid
join posttags pt on pt.postid=p.id
join tags t on t.id=pt.tagid
where p.posttypeid=1
group by t.tagname
having count(case when lower(u.location) like '%nigeria%' then 1 end) > 10
and count(case when lower(u.location) like '%iceland%' then 1 end) > 15

Enter Parameters

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