Skip to main content
All Problems
hard0% acceptance

Repeat Purchase Rate by Month

Calculate the repeat purchase rate for each month. A 'repeat purchaser' is a customer who placed more than one order that month. For each month (YYYY-MM), show total unique customers, repeat customers, and the repeat rate as a percentage (rounded to 1 decimal). Sort by month.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute