Chapter 24.2, Problem 3SC

Explanation of Solution

Query to find the names of all customers:

The below query is used to select the names of all customers except from Alaska and Hawaii in the “Customer” table.

SELECT Name FROM Customer WHERE State <> 'AK' AND State <> 'HI';

Explanation:

In the above query,

• “SELECT” – It is used to extract values of the “Name” field from the “Customer” table...