2.number of posts related to Airflow or Snowflake

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

select 
t.tagname as name_of_tag,
count(p.id) as total_unique_posts
from posts p
inner join posttags pt
  on (p.id = pt.postid)
inner join tags t
on (pt.tagid = t.id
    and ((t.tagname like '%airflow%') or (t.tagname like '%snowflake%')))
where
((p.tags like '%airflow%') or 
 (p.tags like '%snowflake%'))
group by t.tagname
order by total_unique_posts desc

--where 
--tagname in('airflow','snowflake')

--select 
--top 100 tagname 
--from tags

--54557682
--145298467

Enter Parameters

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