SELECT brand_agg_name, mth_id, sum(mix_usd_amt)
FROM mediatools_week_d_v_gc
WHERE brand_agg_name = 'ACE'
AND mth_id IN ('20230301')
GROUP BY brand_agg_name, mth_id