CASE WHEN post_image IS NOT NULL THEN 'Post with Image' ELSE 'Post with Text' END AS post_category,

COUNT(*) AS post_count

near.social.fact_posts

GROUP BY

CASE WHEN post_image IS NOT NULL THEN 'Post with Image' ELSE 'Post with Text' END;