MongoDB Query for Last 24 Hours | Dataford Interview Questions

Write a basic MongoDB query to find all users who registered in the last 24 hours.

For this PostgreSQL version, use the users table and its registered_at timestamp column. Return only registrations from the previous 24 hours through the current time.

Output

One row per qualifying user, with columns user_id, username, email, and registered_at
Exclude users outside the time range and users with a future or NULL registration timestamp
Order by registered_at descending, then user_id ascending

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
username	VARCHAR(100)	User login name
email	VARCHAR(255)	User email address
registered_at	TIMESTAMPTZ	Timestamp when the user registered

Your question is MongoDB Query for Last 24 Hours. 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