SQL Window Running Metrics

Write a query using SQL window functions to calculate running totals and moving averages of user API requests over a trailing thirty-day window.

Use oracle_users and api_requests. Return one row for each user and calendar date on which that user made requests. The moving average should average daily request counts from the current date and the preceding 29 calendar days. Exclude requests that cannot be matched to a user.

Output

1. Columns: user_id, user_name, request_date, daily_requests, running_total, and moving_avg_30d
2. One row per user and request date, ordered by user_id and request_date
3. Round moving_avg_30d to two decimal places