Design a daily_sales_summary table that pre-aggregates transaction data by date and product

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 transaction data by date and product. Include metrics like total_revenue, units_sold, and transaction_count to avoid querying raw transactions for reports.

Practice This Problem

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