1.Question 1What is filtering in SQL?1 pointChanging a table to match a conditionRemoving unnecessary data from the databaseRemoving invalid recordsSelecting data that match a certain condition2.Question 2You are working with the Chinook database and want to return the firstname, lastname, and phone of all employees. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)12--???FROM employees;RunResetWhat is Andrew Adams' phone number?1 point+1 (403) 467-3351+1 (780) 836-9987+1 (403) 262-3443+1 (780) 428-94823.Question 3A security analyst wants to filter the log_in_attempts table for records where the value in the country column is 'Canada'. What is a valid query for this?1 pointSELECT WHERE country = 'Canada'FROM log_in_attempts;SELECT *FROM log_in_attemptsWHERE country = 'Canada';SELECT *FROM log_in_attemptsWHERE country = Canada;WHERE country = 'Canada'SELECT *FROM log_in_attempts;4.Question 4Which pattern matches with any string that starts with the character 'A'?1 point'%A''A''A%''%A%'

Question 3You are working with the Chinook database. You want to find the first and last names of customers who have a value in the country column of either 'Brazil' or 'Argentina'. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

2.Question 2Text match. Type the missing command name in the following SQL statement to change the record of data where staffID = 10. 1______________ INTO Staff(staffID, FullName, Salary) VALUES (10, “Mark Carlson”, 30000);

You have a database with a customers table. Here is a partial listing of the records:First_NameLast_NameMichelleSenseAlexisRodriguezFloraSatoYou also have a table of employees. Here is a partial listing of the records:First_NameLast_NameSamuelClementineAlexisRodriguezJabariReddyYou want to create a query that will not return “Alexis Rodriguez” as part of the results. You begin typing your query:SELECT First_Name, Last_Name FROM customers________SELECT First_Name, Last_Name FROM employeesWhat should you type in the blank space between the two queries? (Please type your answer all in upper case. Example: SELECT)

While working as an analyst, you encounter a query that includes the following filter:SELECT *FROM customersWHERE country = 'USA' AND state = 'NV';What will this query return?1 pointInformation about customers who do not have a value of  'USA' in the country column but do have a value of  'NV' in the state column.Information about customers who do not have a value of 'USA' in the country column or do not have a value of  'NV' in the state column.Information about customers who have a value of 'USA' in the country column or a value of  'NV' in the state column.Information about customers who have a value of 'USA' in the country column and a value of 'NV' in the state column.

Which SQL clause is used to filter records?