Tell me about your SQL experience and how you use SQL to support reporting and analytics needs.
Using the supplied reporting tables, write a query that produces the March 2025 account-level messaging report while incorporating the preceding two months for comparisons. Include active accounts eligible by March 31, including accounts with no delivered messages.
Output
- One row per eligible account for March 2025.
- Columns:
account_name, tier, delivered_messages, delivered_units, month_over_month_change, three_month_units, and tier_rank.
- Rank highest delivered units first within each tier, placing ties at the same rank and sorting final rows by
tier, tier_rank, and account_name.
