This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Budget Planner at Meta. The finance team wants to identify campaigns that are spending above the platform average to flag for budget review. The "average" is the mean of each campaign's total spend (not the mean of daily rows). This requires a subquery that first computes total spend per campaign, then averages those totals.
You are a Budget Planner at Meta. The finance team wants to identify campaigns that are spending above the platform average to flag for budget review. The "average" is the mean of each campaign's total spend (not the mean of daily rows). This requires a subquery that first computes total spend per campaign, then averages those totals.