Create a product summary table that caches pre-computed aggregates (total revenue, order count)

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Create a product summary table that caches pre-computed aggregates (total revenue, order count). This is a deliberate denormalization for read performance.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.