Coding Assignment Approach | Dataford Interview Questions

Describe the approach you would use in a coding assignment.

For this SQL coding assignment, use the consultants and assignments tables to report completed assignment totals for every consultant. Include consultants with no completed assignments and treat missing billable hours as zero.

Output

One row per consultant, including consultants without completed assignments.
Columns: consultant_name, completed_assignments, and completed_hours.
Sort by completed assignment count descending, then consultant name ascending.

Schema

consultants

Column	Type	Description
consultant_idPK	INT	Unique consultant identifier
consultant_name	VARCHAR(100)	Consultant display name
department	VARCHAR(100)	Consultant department

assignments

Column	Type	Description
assignment_idPK	INT	Unique assignment identifier
consultant_id	INT	Consultant assigned to the work
assignment_name	VARCHAR(150)	Assignment name
status	VARCHAR(30)	Current assignment status
billable_hours	DECIMAL(8,2)	Billable hours recorded for the assignment

Your question is Coding Assignment Approach. 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.

Problem