Third

1

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

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