J02IntermediateLEFT JOIN · COUNT

Engineer release ownership

Return every engineer as engineer_id, name, and deployment_count, including engineers with zero deployments. Sort by count descending, then name.

Data available

Use these tables

2 tables · 1 relationship

Table 1

engineers

Forward-deployed engineers who own releases.

engineer_idintegerPK
nametext
teamtext

Table 2

deployments

Customer releases, including failures and rollbacks.

deployment_idintegerPK
customer_idintegerFK
engineer_idintegerFK
versiontext
statustext
deployed_attimestamptz

How the tables connect

deployments.engineer_id=engineers.engineer_id

Query editor

PostgreSQL

⌘↵ Run query

Result stream

Output

Run your query to inspect its result.

Contextual coach

Ask about this attempt

Run or check a query first. The coach only comments on a real error or grader mismatch.

Field notes

Hints & explanation

Try to solve it cold. Two progressive hints are available.