SQL Customer Purchase Behavior Analysis

Summary

A MySQL analysis project that segmented customers by purchase behavior and surfaced revenue concentration, repeat purchase, retention, and CLV insights.

Feature List

• Wrote multi-table JOINs, HAVING filters, and correlated subqueries
• Analyzed 10,000+ transactions
• Found the top 10% of customers contributed 55% of revenue
• Calculated AOV, repeat purchase frequency, retention rate, and CLV improvement insights