Can you explain your approach to optimizing queries within the BigQuery environment?
For this practical exercise, write a PostgreSQL query that returns customer revenue from qualifying 2025 orders. Apply a performance-conscious approach by limiting data to the required period and status before producing the final customer-level results.
Output
- One row per customer with at least 100.00 in qualifying revenue.
- Columns:
customer_id, customer_name, region, total_revenue, and completed_orders.
- Sort by
total_revenue descending, then customer_id ascending.
