How would you design a SQL query using window functions to calculate rolling 30-day approval rates by customer segment at Inizio Partners?