Select Date in SQL | Dataford Interview Questions

How do you select a specific date from a table using SQL?

Asked in the Round 1 stage. Verbal explanation.

Using activity_log and customers, return all activities that occurred on February 14, 2025, with the associated customer information.

Output

One row per matching activity.
Columns: customer_name, activity_id, occurred_at, activity_date, and action_type.
Include only activities on the specified calendar date, ordered by occurred_at ascending and activity_id ascending.

customers

activity_log

Column	Type	Description
activity_idPK	INT	Unique activity identifier
customer_id	INT	Customer associated with the activity
occurred_at	TIMESTAMP	Timestamp when the activity occurred
action_type	VARCHAR(40)	Type of activity performed

Your question is Select Date in SQL. Start with the requirements and the two tables 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.