with ads_data as ( SELECT ad_id, adset_id, campaign_id, status, sum(impressions) clicks, sum(spend) as investment FROM `reby-cloud.facebook_ads.insights` ai left join `reby-cloud.facebook_ads.ads` ads on ai.ad_id = ads.id --WHERE DATE(_PARTITIONTIME) = "2021-07-06" group by 1,2,3,4 ) select * from ads_data where ad_id = '23843560033720454' order by clicks desc