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

Repeat Purchase Rate

Return the percentage of customers who have placed two or more orders, rounded to two decimals, as repeat_rate.

Table schema

Orders(id INT PRIMARY KEY, customer_id INT)

Sample data

id | customer_id
1 | 1
2 | 1
3 | 2
4 | 3
5 | 3
6 | 3

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.