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

L5

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.

Summary

Users segmented by spending behavior.

Practice This Problem

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