Online Course Support | Prepare Data for Exploration

You are working with a database table that contains customer data. The city column lists the city where each customer is located. You want to find out which customers are located in Berlin.

 
 
Correct

The clause WHERE city = ‘Berlin’ will return only customers located in Berlin. The complete query is SELECT * FROM customer WHERE city = ‘Berlin’. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. Place quotes around text values. There are two customers located in Berlin.

Similar Posts