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