select top 100 * from PostTags pt inner join Tags t on pt...

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 top 100 * from PostTags pt
inner join Tags t
on pt.TagId = t.Id
where 
(lower(t.TagName) like '%airflow%' or lower(t.TagName) like '%snowflake%') 
and pt.PostId = 60301105
-- where Tags like 
-- PostTypeId  = 2
-- AnswerCount is not null

Enter Parameters

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