SQL Proficiency Snippet | Dataford Interview Questions

Can you provide a code snippet that demonstrates your proficiency in SQL?

Provide a PostgreSQL query using the encounters table to summarize completed encounters by department. Include a count and the average length of stay.

Output

One row per department with completed encounters only.
Columns: department, encounter_count, and avg_length_of_stay_days.
Order by encounter count descending, then department alphabetically.

Schema

encounters

Column	Type	Description
encounter_idPK	INTEGER	Unique encounter identifier
department	VARCHAR(50)	Department associated with the encounter
encounter_status	VARCHAR(20)	Current status of the encounter
length_of_stay_days	INTEGER	Length of stay measured in days

Your question is SQL Proficiency Snippet. 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