SQL for Last 30 Days | Dataford Interview Questions

A customer communications team needs to identify recent records with usable active phone numbers. Write a SQL query to return qualifying customer records from the last 30 days relative to September 15, 2026.

Output

Return all columns from customer_records.
Include records dated from August 16, 2026 through September 15, 2026, inclusive.
Include only records with phone_status equal to active and a non-null, non-empty phone_number.
Sort the results by record_id in ascending order.

Schema

customer_records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
person_name	VARCHAR(100)	Name associated with the record
activity_date	DATE	Date of the recorded activity
phone_number	VARCHAR(25)	Phone number associated with the record
phone_status	VARCHAR(20)	Current status of the phone number

Your question is SQL for Last 30 Days. 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

Output

Return all columns from customer_records.
Include records dated from August 16, 2026 through September 15, 2026, inclusive.
Include only records with phone_status equal to active and a non-null, non-empty phone_number.
Sort the results by record_id in ascending order.

Schema

customer_records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
person_name	VARCHAR(100)	Name associated with the record
activity_date	DATE	Date of the recorded activity
phone_number	VARCHAR(25)	Phone number associated with the record
phone_status	VARCHAR(20)	Current status of the phone number

Your question is SQL for Last 30 Days. 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.