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.

While working as an analyst, you encounter a query that includes the following filter:SELECT *FROM customersWHERE country = 'USA' AND state = 'NV';

1.Question 1True or False: AND, OR, NOT, IN, BETWEEN, and LIKE operators are all used to combine multiple filter conditions in the WHERE clause.1 pointTrueFalse2.Question 2What should be the correct WHERE clause condition to filter out customers who are not from any of these countries – USA, UK.1SELECT * FROM Customers WHERE ___________________________;1 pointWHERE Country NOT 'USA' OR Country NOT 'UK';WHERE NOT(Country = 'USA' OR Country = 'UK');3.Question 3If this query is written based on the Products table below, what would be the result?1SELECT quantity from Products WHERE quantity BETWEEN 2000 AND 8000;Table of Products1 point50002000, 5000, 8000 2000, 5000, 8000, 80004.Question 4What is the result of the following query when enacted on the Author table?123SELECT Author_name FROM Author WHERE Author_name LIKE '%an';1 pointS.B. Swaminathan, Thomas MorganEvan Hayek, S.B. Swaminathan, Thomas Morgan 5.Question 5True or False: There is no SELF JOIN clause in MySQL.1 pointTrueFalse6.Question 6A database contains two tables. An orders table (which is the left table), and the suppliers table (which is the right table).A JOIN is performed on the two tables. The output of this JOIN produces the following table of data:What type of JOIN has been performed here? 1 pointINNER JOINRIGHT JOINLEFT JOIN7.Question 7What JOIN keywords can be used to perform a SELF JOIN? Select all that apply.1 pointLEFT JOINRIGHT JOININNER JOIN8.Question 8How many tables do you need to create a SELF JOIN?1 pointOne tableTwo tables9.Question 9True or False: This SQL statement finds out the number of orders made by each customer.1SELECT COUNT(*) FROM Orders GROUP BY customerID;1 pointTrueFalse10.Question 10Select the missing SQL keyword to find the employees who have worked for more than 12 hours in total.1SELECT Emp_Name, SUM(Working_Hours) FROM Timesheet GROUP BY Emp_Name _________ SUM(Working_Hours) > 12;Timesheet table1 pointHAVINGGROUP

Which SQL clause is used to filter records?

Which SQL clause is used to filter rows based on specified conditions?GROUPFILTERWHEREHAVING

Question 6Fill in the blank: The SQL clause SELECT * is used to retrieve all data from a particular _____.