Join Tables With Date Filter | Dataford Interview Questions

Your question is Join Tables With Date Filter. Start with the requirements and the one table on the right.

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

Problem

ALTEN Technology USA needs a list of project events recorded in its engineering delivery tracking system during a defined reporting period. Write a PostgreSQL query that returns events from February 1, 2025 through February 28, 2025.

Requirements

Return the event ID, project name, event date, and status for events within the specified date range.
Exclude rows with a NULL event date and sort the results chronologically, using the event ID as a tie-breaker.

Use an inclusive start date and an exclusive end date so the query remains reliable if event_date is later changed from DATE to TIMESTAMP.

Schema

project_events

Column	Type	Description
event_idPK	INTEGER	Unique event identifier
project_name	VARCHAR(100)	ALTEN Technology USA project name
event_date	DATE	Date when the event occurred
status	VARCHAR(30)	Current event status

Your question is Join Tables With Date Filter. Start with the requirements and the one table on the right.

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

Requirements

Return the event ID, project name, event date, and status for events within the specified date range.
Exclude rows with a NULL event date and sort the results chronologically, using the event ID as a tie-breaker.

Use an inclusive start date and an exclusive end date so the query remains reliable if event_date is later changed from DATE to TIMESTAMP.

Schema

project_events

Column	Type	Description
event_idPK	INTEGER	Unique event identifier
project_name	VARCHAR(100)	ALTEN Technology USA project name
event_date	DATE	Date when the event occurred
status	VARCHAR(30)	Current event status