How would you write a SQL query using window functions to rank customers by revenue within each region and calculate their running totals?
