Customer Segmentation

Write a SQL query to segment customers based on total spending: Premium (>50000), Standard (10000-50000), Basic (<10000).

Expected Columns

• segment
• customer_count
• total_revenue

Example Output

| segment | customer_count | total_revenue | |---------|----------------|---------------| | Premium | 4 | 319850.0 | | Standard | 3 | 39700.0 | | Basic | 3 | 10650.0 |