The conditional expressions of SQL are mentioned below:
In the options only CASE statement is conditional expression. Hence, option C (CASE) is the correct answer.
Here is the syntax to use the CASE statement:
CASE WHEN condition1 THEN result1
WHEN condition2 THEN result2
You can go through SQL tutorial by Intellipaat to learn conditional expressions in SQL.