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

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

The REPLACE function in SQL is used to:

The employee table contains information about employees. One of your employees got married, so herlast name changed. What command should you use to reflect this change in the table?

Fill in the blank: A data professional uses the SQL _____ statement to return records that meet conditions by including an if/then statement in a query.1 pointCASEHAVINGWHENCONCAT

Select ID, name, dept name, salary * 1.1 where instructor;The query given below will not give an error. Which one of the following has to be replaced to get the desired output?*Salary*1.1IDWhereInstructor