PostgreSQL Completed Order Metrics per User

General ML questions. Some SQL queries.

Using the provided users and orders tables, write a PostgreSQL query that returns users with at least two completed orders. Include only completed orders when calculating the requested metrics. Handle nullable order amounts according to standard PostgreSQL aggregate behavior.

Output

1. One row per qualifying user.
2. Columns: user_id, user_name, completed_order_count, total_spend, avg_order_value, and latest_order_date.
3. Sort by total_spend descending, then user_id ascending.

Output details

• Round avg_order_value to 2 decimal places.