Write a SQL query to extract and aggregate crash metrics from a highly nested operational vehicle dataset over a rolling 30-day window for AURORA.