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';

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;

Select Any One Of the Following Options: Primary data can be collected by__________________.Conducting experimentsObserving the respondentsDirect communication with the respondentsAll of these

Question 5When querying a table called Teachers that contains a list of teachers and the city they teach in, which of the following queries will return the number of teachers from each city?1 pointSELECT distinct(City) FROM Teachers SELECT City, count(City) FROM TeachersSELECT City, count(City) FROM Teachers GROUP BY CitySELECT City, distinct(City) FROM Teachers GROUP BY City6.Question 6You want to retrieve a list of employees by first name and last name for a company that are between the ages of 30 and 50. Which clause would you add to the following SQL statement: SELECTFirst_Name,Last_Name, Age FROM Company1 pointWHERE Age > 30IF Age >=30 AND Age <=50WHERE Age < 30WHERE Age >=30 AND Age <=50

Sally created a survey to determine the leisure activities of year 6 students.She asked a randomly selected group of 10 girls and 10 boys to answer the questions.Which statement below is correct about Sally's survey.Question 1Select one:A.Sally had conducted a census, collecting qualitative and quantitative data.B.Sally had conducted a sample, collecting qualitative and quantitative data.C.Sally had conducted a sample, collecting qualitative data only.D.Sally had conducted a census, collecting quantitative data only.

What type of survey methodology would you use to conduct for a sample of 500 of the following:(a) Visitors to a multi-venue cultural festival. (b) Museum volunteers.(c) The users of an arts centre.(d) Visitors to the cultural precinct of a city.(e) People visiting a country to attend a major international cultural or sport event.(f) People who are not attendees at performing arts venues.(g) Members of a theatre group. (h) Amateur musicians in a city.(i) People aged 14 and over living in a local council area. (j) Young people aged 11–13 living in a local council area.