CASE Statements

CASE is used for conditional logic within SQL queries.

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

It works like an if-else ladder to assign labels or values based on conditions.