and am looking to add another column to the data where if the total_bid_strategy_active_spend is greater than 0, to have the entry "1" and if it is equal to 0 to have the entry "0"
SELECT
total_bid_strategy_active_spend,
CASE
WHEN total_bid_strategy_active_spend>0 THEN 1
ELSE 0
END AS is_total_bid_strategy_active_spend_gt_0,
country,
agency_name,
holding_company,
year_week,
advertiser_name
FROM amitvaria.key_metrics_historical;