The Weight of Things

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

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 claims part of the year. Find where it gathers.

Practice This Problem

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