As a junior database analyst, you have been asked to retrieve the list of all customers from a 'Customers' table who are located in Paris. Which SQL command should you use to accomplish this task?
SELECT * FROM PurchaseHistory WHERE city = 'Paris';
The correct answer is SELECT * FROM Customers WHERE city = 'Paris'; because the asterisk selects all columns, and the WHERE clause filters rows so that only those whose City value equals 'Paris' are returned. The other options are incorrect because they have invalid syntax, reference the wrong table, or return only the city column instead of complete customer records.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does the asterisk (*) do in a SQL SELECT statement?
Open an interactive chat with Bash
What is the purpose of the WHERE clause in SQL?
Open an interactive chat with Bash
Why is it important to reference the correct table in a SQL query?