Where the Money Pools

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

We run a card-payments platform, and merchandising wants to see where this year's spend is concentrating across product categories. For each category, show its 2026 revenue and that revenue as a plain fraction of the year's total spend (a value between 0 and 1, not rounded), biggest categories first.

Summary

Every category takes a slice of the year's spend. Find who takes the most.

Practice This Problem

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