Question

You’re a data analyst for a sports arena who wants to better understand their customers who attend soccer games. At every event, attendees are asked to fill out a survey. The sports arena keeps the responses in the data table CustomerSurveys. Which query should you use to examine only the data from customers who attended soccer games?


4123
SELECT *
FROM CustomerSurveys
FILTER = 'soccer';




1234
SELECT *
FROM CustomerSurveys
WHERE event = 'soccer';




1234
SELECT *
FROM CustomerSurveys
WHERE 'soccer';




123

Answer 1

Use the second query:

SELECT *
FROM CustomerSurveys
WHERE event = 'soccer';

Reason: WHERE filters rows by a condition (here the event column equals the string 'soccer'). The first option uses an invalid FILTER syntax; the third has an invalid WHERE clause (just a string literal).