This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Revenue Analyst at Meta. The sales team needs to identify the top 5 advertisers by total advertising spend for a quarterly business review. This requires traversing three tables: daily_performance (where spend is recorded), campaigns (to link spend to advertisers), and advertisers (for company details). The report should also show how many distinct campaigns each advertiser ran.
You are a Revenue Analyst at Meta. The sales team needs to identify the top 5 advertisers by total advertising spend for a quarterly business review. This requires traversing three tables: daily_performance (where spend is recorded), campaigns (to link spend to advertisers), and advertisers (for company details). The report should also show how many distinct campaigns each advertiser ran.