The Employees table contains repeat entries in the JobTitle column, as many employees share the same job title.Which code snippet ensures that a query will list each job title once, independent of how many times it appears in the JobTitle column?SELECT JobTitle = 1SELECT UNIQUE JobTitleSELECT COUNT(JobTitle) = 1

Question 3You write a SQL query that will count values in a specified range. Which function should you include in your query to only count each value once, even if it appears multiple times?

Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY> ANY(SELECT SALARY FROM EMPLOYEE);Prints10950

In a database system with an "orders" table, write a query to count the number of unique salespeople.Return the number of unique salespeople.

Consider the following SQL statement:SELECT employee_id FROM employeesUNIONSELECT employee_id FROM former_employees;What does this statement do?Returns the employee IDs of all current employees.Returns the employee IDs of all former employees.Returns the employee IDs of both current and former employees, eliminating duplicates.Returns the employee IDs of both current and former employees, including duplicates.

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