Question $7$

Examine the following CASE statement. What is missing?

SELECT CustomerID,

CASE stateCode

WHEN $\text{'}$AZ$\text{'}=$'Arizona'

WHEN $\text{'}$TX$\text{'}=$ 'Texas'

WHEN $\text{'}$ME$\text{'}=$ 'Maine'

ELSE 'Some Other State'

FROM tblcustomers;

An END statement

A semicolon after the ELSE statement

A WHERE clause

Nothing