Chapter 23, Problem 9RE

Explanation of Solution

SQL query that lists all customers in California or Nevada:

Consider the below “SELECT” query that displays all customers’ names in California or Nevada:

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

SELECT Name

FROM Customer

WHERE State = 'CA' OR State = 'NV';

Explanation:

• The above “SELECT” query that fetches all “Name” from the “Customer” table where the “state” is “'CA'” OR “State” is “'NV'”
  • Here, “Name” – It refers to the column name from which data is extracted.
  • “Customer” – It is the name of the table from which the information is retrieved.
  • “WHERE” – It is a keyword used to filter and retrieve individual row from a table...