3

0

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

Enter Parameters

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