Question

1. 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. you write the sql query below. select * from customer what code would be added to return only customers located in berlin? ∘ join city = berlin ∘ city = berlin ∘ in city = berlin ∘ where city = berlin

Explanation:

To filter rows in an SQL query to only return records that match a specific condition, the WHERE clause is used. JOIN is for combining tables, a standalone condition without WHERE is invalid syntax, and IN is used to match against a set of values, not for this simple equality filter.

Answer:

WHERE city = 'Berlin'