[Solved] You want to assign a grade based on Score in a table:- Score ≥ 90: 'A'- Score ≥ 80 and < 90:... 70 and < 80: 'C'- Otherwise: 'F'Which CASE expression correctly implements this grading logic? | SQL

SQL - CASE Expressions

You want to assign a grade based on Score in a table:
- Score ≥ 90: 'A'
- Score ≥ 80 and < 90: 'B'
- Score ≥ 70 and < 80: 'C'
- Otherwise: 'F'
Which CASE expression correctly implements this grading logic?

ACASE WHEN Score ≥ 90 THEN 'A' WHEN Score ≥ 80 THEN 'B' WHEN Score ≥ 70 THEN 'C' ELSE 'F' END

BCASE WHEN Score < 70 THEN 'F' WHEN Score < 90 THEN 'C' WHEN Score < 80 THEN 'B' ELSE 'A' END

CCASE WHEN Score ≥ 70 THEN 'C' WHEN Score ≥ 80 THEN 'B' WHEN Score ≥ 90 THEN 'A' ELSE 'F' END

DCASE Score WHEN ≥ 90 THEN 'A' WHEN ≥ 80 THEN 'B' WHEN ≥ 70 THEN 'C' ELSE 'F' END

Step-by-Step Solution

Solution:

Step 1: Understand the grading order
Grades must be checked from highest to lowest score to assign correct grade.
Step 2: Analyze each option
CASE WHEN Score ≥ 90 THEN 'A' WHEN Score ≥ 80 THEN 'B' WHEN Score ≥ 70 THEN 'C' ELSE 'F' END checks from highest to lowest correctly; CASE WHEN Score < 70 THEN 'F' WHEN Score < 90 THEN 'C' WHEN Score < 80 THEN 'B' ELSE 'A' END incorrectly assigns scores 70-89 to 'C'; CASE WHEN Score ≥ 70 THEN 'C' WHEN Score ≥ 80 THEN 'B' WHEN Score ≥ 90 THEN 'A' ELSE 'F' END checks in wrong order; CASE Score WHEN ≥ 90 THEN 'A' WHEN ≥ 80 THEN 'B' WHEN ≥ 70 THEN 'C' ELSE 'F' END uses invalid CASE syntax.
Final Answer:
CASE WHEN Score ≥ 90 THEN 'A' WHEN Score ≥ 80 THEN 'B' WHEN Score ≥ 70 THEN 'C' ELSE 'F' END -> Option A
Quick Check:
Order conditions high to low in CASE [OK]

Quick Trick: Check conditions from highest to lowest in CASE [OK]

Common Mistakes:

Checking conditions in wrong order
Using CASE with invalid syntax
Assuming CASE compares values directly without WHEN

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

You want to assign a grade based on Score in a table:

Step 1: Understand the grading order

Step 2: Analyze each option

Final Answer:

Quick Check:

Want More Practice?