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'

Question

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'

Quizplus · Accepted Answer

The correct SQL syntax to select all columns is `SELECT *`, and to specify conditions that must not match, we use `<>` for not equal. Therefore, option C correctly uses both `SELECT *` to select all columns and `<> 'TX'` to exclude customers from Texas, while also checking for the payment method to be American Express with `PaymentMethod = 'AMEX'`.

You Need to Write a Query to Retrieve All Customer