0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for materials modelers and data scientists

select
    year (posts.creationdate) as year,
    tagname,
    count(*) as count
from posttags
join tags on posttags.tagid = tags.id
join posts on posttags.postid = posts.id
join posttypes on posts.posttypeid = posttypes.id
join users on posts.owneruserid = users.id
where
    posttypes.name = 'Question'
    and year(posts.creationdate) = 2016
    and (
        lower(location) like '%canada%'
        or lower(location) like '%alberta%'
        or lower(location) like '%british columbia%'
        or lower(location) like '%manitoba%'
        or lower(location) like '%nova scotia%'
        or lower(location) like '%ontario%'
        or lower(location) like '%quebec%'
        or lower(location) like '%saskatchewan%'
        or lower(location) like '%calgary%'        
        or lower(location) like '%edmonton, ab%'        
        or lower(location) like '%guelph%'
        or lower(location) like '%halifax, ns%'
        or lower(location) like '%hamilton, on%'
        or lower(location) like '%kitchener%'
        or lower(location) like '%london, on%'
        or lower(location) like '%montreal%'
        or lower(location) like '%ottawa%'
        or lower(location) like '%regina%'
        or lower(location) like '%saint john, nb%'
        or lower(location) like '%saskatoon%'
        or lower(location) like '%toronto%'
        or lower(location) like '%vancouver%'
        or lower(location) like '%victoria, bc%'
        or lower(location) like '%waterloo, on%'
        or lower(location) like '%winnipeg%')
group by
    year(posts.creationdate),
    tagname
order by
    year(posts.creationdate),
    count(*) desc;

fork query

created jan 17 anonymous