# The Vote Tally

> Net revenue, day by day, for one product in one region.

Canonical URL: <https://datadriven.io/problems/aggregate_votes_by_paper_subject>

Domain: SQL · Difficulty: hard · Seniority: L5

## Problem

Finance is reconstructing the daily revenue picture for product 1001. For each transaction date that the product has activity on, show the net revenue (sum of transaction amounts), in chronological order.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/aggregate_votes_by_paper_subject)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.