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') and the payment method (field is 'PaymentMethod') is American Express ('AMEX') . Which of the following SQL statements will work for your query?

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