What will be the output of the following SQL statement: "SELECT COUNT(*) FROM Employees WHERE Salary > 50000"?It will return the total salary paid to the employees who earn more than 50000It will return the average salary of the employees who earn more than 50000It will return the number of employees who earn more than 50000None of the above

Which of the following SQL statements can extract employee name’s whose salary is $10000 or higher from the table “human_resource”? SELECT employee_name, COUNT(*) FROM human_resourceWHERE salary>=10000 GROUP BY employee_nameSELECT employee_name FROM human_resourceWHERE salary>=10000SELECT employee_name, salary FROM human_resourceGROUP BY salary HAVING COUNT(*)>=10000SELECT salary FROM human_resourceWHERE employee_name >=10000 GROUP BY salary

What will the following SQL query return? SELECT AVG(salary) AS average_salary FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE department_name = 'IT');Select one:a. The number of employees in the IT department.b. The total salary of employees in the IT department.c. The highest salary of employees in the IT department.d. The average salary of employees in the IT department.

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

A  B  C  D  E 1  IDENTICATION NUMBER  BASIC SALARY (N)  TOTAL ALLOWANCE (N)  TOTAL DEDUCTION (N)  NET SALARY (N) 2  WASC/LPT/001  800000  60000  40000  820000 3  WASC/LPT/002  700000  40000  20000  720000 4  WASC/LPT/003  300000  10000  5000  305000 5  WASC/LPT/004  400000  20000  10000  410000 Figure 3What formula will calculate the total number of individuals who earn less than ₦500,000 from the table as shown in Figure 3?A. =COUNT(E2:E5,B. =COUNT(E2:E5)C. =COUNTA(E2:E5)D. =COUNTIF(E2:E5,

To display the names of employees who earns more than the average salary of allemployees.SELECT last_name, first_nameFROMemployeeWHEREsalary > AVG(salary);Which change should you make to achieve the desired results?Select one:a.Use a subquery in the WHERE clause to compare the average salary value.b.Change the function in the WHERE clause.c.Move the function to the SELECT clause and add a GROUP BY clause.d.Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.