Given an orders table with customer_id, order_date, and amount, write a query that returns customers whose average order value has increased in each of the last three months compared to the prior month.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

Given an orders table with customer_id, order_date, and amount, write a query that returns customers whose average order value has increased in each of the last three months compared to the prior month.

Practice more