In the Litware price groups T-SQL example, which keyword completes the statement to start the CASE expression within the SELECT?

In the Litware price groups T-SQL example, which keyword completes the statement to start the CASE expression within the SELECT?

• A. WHEN
• B. THEN
• C. END
• D. CASE

Answer: (D)

CASE opens a conditional expression in T-SQL. It signals that you’re about to evaluate conditions with WHEN ... THEN clauses and produce a corresponding result, optionally using ELSE, and finally END to close the expression. The keyword to start the CASE expression is CASE, not WHEN, THEN, or END. For example: SELECT Price, CASE WHEN Price > 100 THEN 'Premium' WHEN Price > 50 THEN 'Standard' ELSE 'Budget' END AS PriceCategory FROM LitwarePrices. This shows how the CASE expression assigns a category based on Price. The other keywords appear inside the expression, not at the start, which is why CASE is the correct first word.

CASE opens a conditional expression in T-SQL. It signals that you’re about to evaluate conditions with WHEN ... THEN clauses and produce a corresponding result, optionally using ELSE, and finally END to close the expression. The keyword to start the CASE expression is CASE, not WHEN, THEN, or END. For example: SELECT Price, CASE WHEN Price > 100 THEN 'Premium' WHEN Price > 50 THEN 'Standard' ELSE 'Budget' END AS PriceCategory FROM LitwarePrices. This shows how the CASE expression assigns a category based on Price. The other keywords appear inside the expression, not at the start, which is why CASE is the correct first word.