Debug a Hive query

You are computing monthly revenue metrics for an e-commerce platform. Using the `users`, `orders`, and `payments` tables described below, write a **single PostgreSQL query** that produces one row per (calendar month, country) combination, restricted to the first quarter of 2025. **Qualifying-order rules** (an order must satisfy ALL of these to be counted): - The order's `status` is `'completed'`. - The order's `order_date` falls between **2025-01-01** and **2025-03-31** (inclusive). - There exists at least one row in `payments` for that order whose `payment_date` is between the order's `order_date` and **7 days after** `order_date` (inclusive). An order is counted **once** no matter how many payments it has. **Output:** For each (month, country) that has at least one qualifying order, return exactly these columns: - `order_month` — the order's month in `YYYY-MM` format (derived from `order_date`). - `country` — the country of the order's user (from `users.country`). - `total_gmv` — the sum of `orders.total_amount` over the qualifying orders in that (month, country). - `paying_users` — the number of **distinct** users who placed at least one qualifying order in that (month, country). - `avg_order_value` — `total_gmv` divided by the **number of qualifying orders** in that (month, country), rounded to 2 decimal places. - `top_customer_id` — the `user_id` whose summed `total_amount` of qualifying orders is the **highest** within that (month, country). Break ties by choosing the **smallest** `user_id`. Sort the result by `order_month` ascending, then `country` ascending.