Question

Question 5
You’re a data analyst for a car manufacturer. You have a data table called CarSales and you want to use it to examine the sales of one of your company’s product lines, which is coded in the data as suv. Which query should you use to examine only the data on suv sales?




123
SELECT suv
FROM CarSales;




1234
SELECT *
FROM CarSales
WHERE product_line = 'suv';




1234

Answer 1

The second query:

SELECT *
FROM CarSales
WHERE product_line = 'suv';

Explanation: the WHERE clause filters rows to only those with product_line = 'suv'. The first query (SELECT suv FROM CarSales) would try to return a column named "suv" instead of filtering rows.