Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Asked 2mo ago|

Coforge

Coforge

Top Error Sources in Coforge Logs

Easy

SubqueriesJoinsAggregations

Problem

Task

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.

Problem

Task

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.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Instacart

Identify Top Transaction Failure PointsMedium

Instacart

Identify Top Partner Error ModesMedium

Aveva

Top Weekly Error CodesEasy

Top Error Sources in Coforge Logs | Dataford Interview Questions