Repeat Purchase Rate
Medium
Analytics Case Studies
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.