The Heavy Lifters

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

A merchandising team treats any order of three or more units as a bulk order and wants to find the categories that lean on them. Return the categories where bulk orders account for more than half of total revenue, giving just the category name.

Summary

In some categories, a handful of big orders carry the rest.

Practice This Problem

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