You Need to Write an SQL Query to Retrieve CustomerFirstName

Multiple Choice

You need to write an SQL query to retrieve CustomerFirstName, CustomerLastName, and CustomerEmailAddress from the Customer table for all customers who list "OK" as their state (field name for state is CustomerState) . Which SQL statement will yield the results that you need?

A) SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState IS 'OK'
B) SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState = 'OK'
C) SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState = 'OK'
D) SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState IS 'OK'