Window Functions for Publisher Revenue

Write a SQL query using window functions to rank publishers by revenue within each day and calculate a running total.

Use completed revenue events only. Treat each publisher and calendar date as one output row.

Output

1. Return publisher_name, revenue_date, daily_revenue, daily_rank, and running_total.
2. Include one row per publisher and date with completed revenue.
3. Rank publishers within each date by descending daily revenue, with equal revenues sharing a rank.
4. Calculate each publisher's cumulative revenue through the displayed date.
5. Order by revenue_date, daily_rank, and publisher_name.