Identify Top Partner Error Modes | Dataford Interview Questions

You are given partner error logs and a lookup of error codes. Write a PostgreSQL query that identifies the top failure modes by partner, showing each partner’s error category, the number of occurrences, and the share of that partner’s total errors. Focus on the most frequent failure modes and exclude partners with no logged errors.

Schema

partner_errors

Column	Type	Description
error_idPK	INT	Primary key for each error event
partner_id	INT	Partner identifier
error_code	VARCHAR(50)	Error code reported by the partner
occurred_at	TIMESTAMP	When the error occurred

error_code_lookup

Column	Type	Description
error_codePK	VARCHAR(50)	Error code key
error_category	VARCHAR(100)	Normalized failure mode name
severity	VARCHAR(20)	Severity label for the code

Your question is Identify Top Partner Error Modes. 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

Schema

partner_errors

Column	Type	Description
error_idPK	INT	Primary key for each error event
partner_id	INT	Partner identifier
error_code	VARCHAR(50)	Error code reported by the partner
occurred_at	TIMESTAMP	When the error occurred

error_code_lookup

Column	Type	Description
error_codePK	VARCHAR(50)	Error code key
error_category	VARCHAR(100)	Normalized failure mode name
severity	VARCHAR(20)	Severity label for the code

Your question is Identify Top Partner Error Modes. 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.