Compute active ad revenue by creation source

You are working on an ads platform and must produce a daily revenue report that breaks active ad revenue down by each ad's creation source. Every timestamp in the data is stored in UTC. An ad is active on a calendar day when ad_impressions holds at least one row for that ad whose impression_time falls on that day. The revenue of an active ad on that day is the total of revenue_usd across the rows of ad_revenue_events belonging to the same ad whose event_time falls on that…