User Spend Segmentation by Category

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

senior

Problem

Compute each user's average basket size (total spend / transaction count) per category from transactions combined with products. Label 'High' if over $500, 'Medium' between $200 and $500, 'Low' under $200. Then produce a per-category, per-segment summary: unique users, total transactions, total sales, and average basket size. Return the category, segment, unique users, total transactions, total sales, and average basket size.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.