Writing SQL for Multiple Scenarios | Dataford Interview Questions

Tell me about a time you wrote SQL queries for 10 different scenarios using a defined data schema.

For this exercise, write ten PostgreSQL queries against the provided schema. Each query should represent a distinct analyst request and demonstrate accurate filtering, joins, aggregation, or NULL handling.

Output

Return one row per scenario with scenario_name and metric_value.
Include exactly ten scenarios, ordered by scenario number.
Use the provided schema and sample data only.

Schema

workers

Column	Type	Description
worker_idPK	INT	Unique worker identifier
worker_name	VARCHAR(100)	Worker name
region	VARCHAR(50)	Worker region
worker_status	VARCHAR(20)	Current worker status
hire_date	DATE	Worker hire date

shifts

Column	Type	Description
shift_idPK	INT	Unique shift identifier
worker_id	INT	Assigned worker identifier
shift_date	DATE	Scheduled shift date
shift_type	VARCHAR(20)	Shift type
hours	DECIMAL(5,2)	Shift duration in hours
shift_status	VARCHAR(20)	Current shift status

applications

Column	Type	Description
application_idPK	INT	Unique application identifier
worker_id	INT	Applicant worker identifier
shift_id	INT	Applied-for shift identifier
applied_at	DATE	Application date
application_status	VARCHAR(20)	Current application status

Your question is Writing SQL for Multiple Scenarios. Start with the requirements and the three 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.

Problem