0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select u.Location, t.TagName, count(*) cnt
from Posts q             
JOIN PostTags pt ON q.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
JOIN Users u ON u.id = q.OwnerUserId
where t.TagName = 'amazon-web-services'
and (
  lower(u.Location) like '%vietnam%'
  or lower(u.Location) like '%viet nam%'
  or lower(u.Location) like '%singapore%'  
  or lower(u.Location) like '%indonesia%'    
  or lower(u.Location) like '%philippines%'    
  or lower(u.Location) like '%thailand%'      
  or lower(u.Location) like '%malaysia%'    
)
and q.CreationDate >= '2019-01-01'
group by u.Location, t.TagName
order by cnt desc

fork query

edited oct 30 19

created oct 30 19 Gabe.Hollombe