Design a daily sales summary table that pre-aggregates revenue and order count by product and date

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

Design a daily sales summary table that pre-aggregates revenue and order count by product and date. Include the component metrics needed for calculating averages.

Practice This Problem

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