A Number for the Seller

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

Domain

Data Modeling

Difficulty

easy

Seniority

L3

Problem

We run an online marketplace where sellers list products, and each product records the date its listing went live and whether that listing is still active, since a seller may delist or relist over time. Every sale is logged line by line with the units sold and the revenue earned. Build the analytics schema behind a daily seller dashboard that shows, for each seller, how many of their listings are currently active and, for each date, the revenue and units their sales earned.

Summary

They want a total. Give them the right schema first.

Practice This Problem

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