SQL CASE When Categorization | Dataford Interview Questions

Write a SQL query that uses CASE WHEN to categorize records.

Categorize each record using its priority_score: scores of 8 or higher are Critical, scores from 5 through 7 are High, scores from 1 through 4 are Standard, and all other values, including NULL, are Unclassified.

Output

Return one row per record with record_id, record_name, and priority_category.
Order results by record_id ascending.

Schema

records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
record_name	VARCHAR(100)	Display name of the record
priority_score	INT	Numeric value used to determine the priority category

Your question is SQL CASE When Categorization. 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

Write a SQL query that uses CASE WHEN to categorize records.

Output

Return one row per record with record_id, record_name, and priority_category.
Order results by record_id ascending.

Schema

records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
record_name	VARCHAR(100)	Display name of the record
priority_score	INT	Numeric value used to determine the priority category

Your question is SQL CASE When Categorization. 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.