SQL for Last 30 Days | Dataford Interview Questions

Write a basic SQL query to pull all records from the last 30 days that have an active phone number.

Assume the relevant date is activity_date. Include only records dated from 30 days ago through today, with phone_status equal to active and a non-null, non-empty phone_number.

Output

Return all columns from the qualifying records.
Return one row per record, ordered by record_id ascending.

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