Q&A for practitioners of the art and science of signal, image and video processing
SELECT top 1000 * FROM PostTags pt LEFT JOIN ( SELECT Id ,TagName FROM Tags WHERE LOWER(TagName) LIKE '%snowflake%' OR LOWER(TagName) LIKE '%airflow%' ) AS tags ON tags.id = pt.TagId -- GROUP BY tags.TagName -- ORDER BY total_unique_posts DESC