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'

Question

Quizplus · Accepted Answer

The correct SQL syntax to filter results based on a condition is to use the WHERE clause followed by the condition. In this case, the condition is that the CustomerState must equal 'OK'. Option C correctly uses WHERE to filter the customers from the state 'OK'.

You Need to Write an SQL Query to Retrieve CustomerFirstName