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

Consider the table EMPLOYEE(empId, name, department, salary) and the two queries Q1 ,Q2 below. Assuming that department D5 has more than one employee, and we want to find the employees who get higher salary than anyone in department D5, which one of the statements is TRUE for any arbitrary employee table?Q1 :  SELECT  e.empId FROM employee e WHERE NOT EXIST (SELECT * From employee s where s.department = “D5” AND  s.salary >=e.salary)Q2 : SELECT  e.empIdFROM employee eWHERE e.salary > Any (Select distinct salary From employee s Where s.department = “D5”)Q1 is the correct queryQ2 is the correct queryBoth Q1 and Q2 produce the same answer.Neither Q1 nor Q2 is the correct query

Consider a table Emp(Name, Salary)SELECT Name FROM Emp WHERE Salary BETWEEN 1000 AND 2000;The above query will display the names from the Emp table whose __________Salary is >1000 and Salary <= 2000Salary is >=1000 and Salary <= 2000Salary is >=1000 and Salary < 2000Salary is >1000 and Salary < 2000

employee_id Name Salary1001 Annie 60001009 Ross 45001018 Zeith 7000above are the Employee table details.select employee_id from employee order by employee_id desc;Which of the following output will be true?

Which of the following queries will return the first name of the employee who earns the highest salary?1 pointSELECT FIRST_NAME FROM EMPLOYEES WHERE SALARY IS HIGHESTSELECT FIRST_NAME, MAX(SALARY) FROM EMPLOYEES GROUP BY F_NAMESELECT MAX(SALARY) FROM EMPLOYEESSELECT FIRST_NAME FROM EMPLOYEES WHERE SALARY = ( SELECT MAX(SALARY) FROM EMPLOYEES )