Top Error Sources in Coforge Logs | Dataford Interview Questions

You are given a single PostgreSQL table that stores Coforge data pipeline log events. Write a query to return the top 3 source_system values with the highest number of rows where status = 'ERROR'. Show the source system and its error count, ordered by error count descending and then by source system ascending.

Schema

coforge_pipeline_logs

Column	Type	Description
log_idPK	INT	Unique log row identifier
source_system	VARCHAR(50)	Upstream source system name
pipeline_name	VARCHAR(80)	Coforge pipeline name
status	VARCHAR(20)	Pipeline event status
records_processed	INT	Number of records processed in the event
event_date	DATE	Date of the pipeline event

Your question is Top Error Sources in Coforge Logs. 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

Schema

coforge_pipeline_logs

Column	Type	Description
log_idPK	INT	Unique log row identifier
source_system	VARCHAR(50)	Upstream source system name
pipeline_name	VARCHAR(80)	Coforge pipeline name
status	VARCHAR(20)	Pipeline event status
records_processed	INT	Number of records processed in the event
event_date	DATE	Date of the pipeline event

Your question is Top Error Sources in Coforge Logs. 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.