Normalization Tradeoffs in Practice

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

The finance team needs total revenue per product category, where revenue for a transaction is defined as the quantity sold times the listed price of the product. Order results by category.

Summary

Clean data or fast queries? You can't always have both.

Practice This Problem

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