Running Sign-Up Total | Dataford Interview Questions

Write a query that calculates the running total of sign-ups per day for the current month.

Assume sign-up timestamps are stored in signup_events. Include dates from the first day of the current month through today, excluding future dates and records without a timestamp.

Output

One row per date with at least one sign-up
Columns: signup_date, signup_count, and running_total
Sort by signup_date ascending

Schema

signup_events

Column	Type	Description
signup_idPK	INT	Unique identifier for the sign-up event
email	VARCHAR(255)	Email address submitted during sign-up
signup_at	TIMESTAMP	Timestamp when the sign-up occurred

Your question is Running Sign-Up Total. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem