Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Customer Lifetime Value Summary

For each customer return the number of orders, the total amount spent and the average order value rounded to two decimals. Order by customer_id.

Table schema

Orders(id INT PRIMARY KEY, customer_id INT, amount INT)

Sample data

id | customer_id | amount
1 | 1 | 100
2 | 1 | 50
3 | 2 | 30

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.