Rolling Alert Counts and Ranking

Write an SQL query using window functions to compute a rolling 7-day count of alerts per customer and rank customers by alert volume within each week for SentinelOne.

Use the customers and alerts tables. Include only alerts associated with a known customer and a non-null alert date.

Output

1. One row per customer and alert date.
2. Return week_start, customer_id, customer_name, alert_date, daily_alerts, rolling_7_day_alerts, weekly_alert_volume, and weekly_rank.
3. Sort by week_start, alert_date, and customer_id ascending. Customers tied on weekly volume share the same rank.