SQL Metrics with Joins | Dataford Interview Questions

Calculate metrics based on a few tables, doing some joins and stuff.

Write a SQL query that returns the requested metrics from the provided tables.

Output

One row per requested entity at the required grain.
Include only the columns specified in the schema and alias them exactly as required.
Sort the result in the required order, with any tie-breakers applied consistently.

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
department_id	INT	Department the employee belongs to
employee_name	VARCHAR(100)	Employee name
employment_status	VARCHAR(20)	Current employment status

projects

timesheets

Column	Type	Description
timesheet_idPK	INT	Unique timesheet entry identifier
employee_id	INT	Employee who logged the hours
work_date	DATE	Date the hours were logged
hours	DECIMAL(5,2)	Hours logged for the day

Your question is SQL Metrics with Joins. Start with the requirements and the four 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.