You Need to Write a Query to Retrieve All Customer

Multiple Choice

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX') . Which of the following SQL statements will work for your query?

A) SELECT * FROM Customer WHERE State <> 'TX'
B) SELECT * FROM Customer WHERE State not = 'TX'
C) SELECT all FROM Customer WHERE State <> 'TX'
D) SELECT all FROM Customer WHERE State not = 'TX'