Which CASE expression would correct a misspelled car type where 'SWV' should be replaced with 'SUV'?

• A. CASE WHEN car_types = 'SWV' THEN 'SUV' END
• B. CASE WHEN car_types = 'SWV' THEN 'SUV'
• C. CASE car_types = 'SWV' THEN 'SUV'
• D. CASE WHEN car_types = 'SWV' THEN 'SUV' ELSE 'SWV' END

Answer: (B)

This question tests how to use a CASE expression to map a specific value to a corrected one. The idea is to check the car type and replace the misspelled label SWV with SUV when it appears. The form that does this by comparing car_types to 'SWV' and returning 'SUV' directly implements the desired substitution. In practice, you’d often add an ELSE clause to keep any other values unchanged, giving CASE WHEN car_types = 'SWV' THEN 'SUV' ELSE car_types END. Other shapes either rely on an invalid syntax or would alter values you don’t intend to change (for example, turning non-SWV values into SWV or producing NULLs for non-matches).