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

Which of the below queries displays employees' name and new salary after the increment of 1000? SELECT ename, sal FROM emp;SELECT ename, sal=sal+1000 FROM emp;SELECT ename, sal+1000 FROM emp;SELECT ename, 1000 FROM emp;Next

SELECT last_name, first_nameFROM employeeWHERE salary IN(SELECT salaryFROM employeeWHERE dept_no = 3 OR dept_no = 5);Which values are displayed?Select one:a.last name and first name of only the employees whose salary falls in the range of salaries from department 3 or 5b.last name and first name of only the employees in department number 3 or 5c.last name and first name of all employees except those working in department 3 or 5d.last name and first name of all employees with the same salary as employees in department 3 or 5

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

Consider the table Employee given below: EmpId EmpName Salary DeptId200 Alex 30000 100201 Tom 20000 101202 Dick 40000 100202 Harry 15000 102205 Mary 50000 101206 Karl 40000 101SELECT EmpName FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DeptId = 100);What will be the outcome of the query given above?

Consider the following EmployeeDetails table.You want to display the details of employees whose salary is more than the lowest salary of department having ID 10.To perform this task, which of the following query you can use the