What the Shelf Never Sold

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

A merchandising team needs a revenue report that covers the entire catalog, not only the products that sold. For each product, give the total revenue it brought in, and make sure products that never sold a unit still appear with zero.

Summary

Some products never moved a single unit. They still belong on the report.

Practice This Problem

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