Running Message Totals in SQL | Dataford Interview Questions

Write a query using SQL window functions to calculate the running total of messages sent per user over a 30-day period.

Use the messages table and evaluate messages from 2024-01-01 through 2024-01-30, inclusive.

Output

messages

Column	Type	Description
message_idPK	INT	Unique identifier for the message
user_id	VARCHAR(20)	Identifier of the user who sent the message
sent_at	TIMESTAMP	Timestamp when the message was sent
message_body	TEXT	Message content

Your question is Running Message Totals in SQL. 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.

Write a query using SQL window functions to calculate the running total of messages sent per user over a 30-day period.

Use the messages table and evaluate messages from 2024-01-01 through 2024-01-30, inclusive.

messages

Column	Type	Description
message_idPK	INT	Unique identifier for the message
user_id	VARCHAR(20)	Identifier of the user who sent the message
sent_at	TIMESTAMP	Timestamp when the message was sent
message_body	TEXT	Message content

Your question is Running Message Totals in SQL. 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.