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? 1 pointSELECT *FROM CarSalesWHERE product_line != 'suv';SELECT *FROM CarSalesWHERE product_line = 'suv';SELECT *FROM CarSales.suv;SELECT suvFROM CarSales;

Question 5You’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? 1 pointSELECT event = 'soccer'FROM CustomerSurveys;SELECT *FROM CustomerSurveysWHERE 'soccer';SELECT *FROM CustomerSurveysWHERE event = 'soccer';SELECT *FROM CustomerSurveysFILTER = 'soccer';

A DEPARTMENTS table contains DEP_NAME, and DEPT_ID_DEP columns and an EMPLOYEES table contains columns called F_NAME and DEP_ID. We want to retrieve the Department Name for each Employee. Which of the following queries will correctly accomplish this?1 pointSELECT D.F_NAME, E.DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE DEPT_ID_DEP = DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE E.DEPT_ID_DEP = D.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT_ID_DEP = DEP_IDSELECT E.F_NAME, D.DEP_NAME FROM EMPLOYEES, DEPARTMENTS

Question 2After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers. 1 point

Question 1You have a table that lists products. Because there are different editions, there are duplicate product names in the productName field. You need to create a list of all of the different product names. If there are different editions of the product, you only want to list one record for each product name. What query should you execute? 1 pointSELECT DISTINCT productName FROM productsSELECT UNIQUE productName FROM productsSELECT INDIVIDUAL productName FROM productsSELECT SEPARATE productName FROM products

Select all that applyWhich of the following allow a company to sell directly to customers effectively?Multiple select question.conducting sales through a company websiteteaming up with rivals to lower pricesmaintaining a direct sales staffasking for better prices from dealers