find_targeting_id.md

SELECT a.level_1 AS level_1, a.level_2 AS level_2, a.display_name AS display_name, c.full_segment_path AS taxo_path, a.targeting_id AS targeting_id, b.count AS count
FROM (SELECT * FROM pre_onboarding) a
LEFT OUTER JOIN (
    SELECT segment_id, COUNT(raw_id) AS count
    FROM yp_test_db.segment_gup
    WHERE country='23424747'
    GROUP BY segment_id) b
ON a.targeting_id=b.segment_id
LEFT OUTER JOIN (
    SELECT full_segment_path, targeting_id FROM ai_stg.lkp_fact_mapping) c
ON a.targeting_id=c.targeting_id;