select t.TagName, count(distinct pt.PostId) c from PostTa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Data Science Meta

Q&A about the site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

-- How many posts are related to either Airflow or Snowflake,
-- order by number of posts? (Hint: tags)
select t.TagName, count(distinct pt.PostId) c
from PostTags pt
inner join Tags t
on pt.TagId = t.Id
where 
(lower(t.TagName) like '%airflow%' or lower(t.TagName) like '%snowflake%') 
group by t.TagName
order by c
-- where Tags like 
-- PostTypeId  = 2
-- AnswerCount is not null

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results