Running Sign-Up Total

MediumSQL · PostgreSQL

Problem

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

Tablessignup_events

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.