Find First Defect Created After Each Deployment

Write a SQL query to find the first defect created after each deployment.

Use the deployments and defects tables. Match records by service; a defect qualifies only when it was created strictly after the deployment. Include deployments with no subsequent defect.

Output

One row per deployment.
Columns: deployment_id, service, deployed_at, defect_id, and defect_created_at.
Return NULL defect values when no qualifying defect exists. Order by deployment_id ascending, breaking ties by the smallest defect_id.

Schema

deployments

Column	Type	Description
deployment_idPK	INT	Unique deployment identifier
service	VARCHAR(100)	Service deployed
deployed_at	TIMESTAMP	Deployment completion timestamp

defects

Column	Type	Description
defect_idPK	INT	Unique defect identifier
service	VARCHAR(100)	Service associated with the defect
created_at	TIMESTAMP	Defect creation timestamp

Your question is Find First Defect Created After Each Deployment. 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