Chapter 23, Problem 8RE

Explanation of Solution

SQL query that lists all customers in California:

Consider the below “SELECT” statement that displays all customers’ names in California:

/* Display the lists of all customers in California */

SELECT Name

FROM Customer

WHERE State = 'CA';

Explanation:

• The above “SELECT” statement that fetches only “Name” column from the “Customer” table where that fulfills a specified condition, that is “State” is equal to 'CA'.
  • “Name” – It refers to the column name from which data is extracted...