Interview Questions Interview Guides Experiences Mock Interviews

Interview Guides

Count Open Defects by Severity | Dataford Interview Questions

All questions/SQL & Data Manipulation

Count Open Defects by Severity

EasyJoinsData WranglingAggregations

Problem

You are given a table of defect records from a BAE Systems USA engineering tracking workflow. Write a SQL query to return the number of open defects for each severity, sorted by the defect count from highest to lowest. Ignore rows where severity is NULL.

Problem

You are given a table of defect records from a BAE Systems USA engineering tracking workflow. Write a SQL query to return the number of open defects for each severity, sorted by the defect count from highest to lowest. Ignore rows where severity is NULL.

Practice SQL

PostgreSQL

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

Up next

Open Defects by PriorityEasy Group Defects by Module and SeverityEasy

AMD

Summarize Operations Issues by SourceMedium