Average Order Value by User

Problem

Write a query returning user_id and avg_order_value from orders.

Why This Matters

Average order value is a common product and ecommerce metric, and it is a clean GROUP BY exercise.

Schema

orders(order_id INT, user_id INT, amount REAL)

Examples

Constraints

• Return the exact requested result.
• Handle common edge cases.
• Keep the solution readable before optimizing.