Whenever you're ready, walk me through how you'd approach this.
How would you use SQL to calculate the average order value for each customer? Explain how you would identify the correct order-level measure, aggregate it per customer, and handle missing or invalid order amounts. Discuss how the result changes if order data is stored at the line-item level rather than one row per order.