[Solved] What will be the output of this query?SELECT name, CASE WHEN score >= 90 THEN 'A' WHEN score >= 80 THEN 'B' ELSE 'C' END AS grade FROM students; | SQL

SQL - CASE Expressions

What will be the output of this query?

SELECT name, CASE WHEN score >= 90 THEN 'A' WHEN score >= 80 THEN 'B' ELSE 'C' END AS grade FROM students;

AOnly students with grade A

BNames with grades A, B, or C based on score ranges

CAn error due to missing ELSE clause

DGrades assigned randomly

Step-by-Step Solution

Solution:

Step 1: Understand multiple WHEN conditions
The CASE checks score ranges: ≥90 = 'A', ≥80 = 'B', else 'C'.
Step 2: Output includes all students with assigned grades
All rows show name and grade based on score, no filtering or errors.
Final Answer:
Names with grades A, B, or C based on score ranges -> Option B
Quick Check:
CASE supports multiple WHEN for ranges [OK]

Quick Trick: Use multiple WHEN for ranges in CASE [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?