he following query throws an error. Choose the correct reason for the error as given in the options. SELECT first_name, last_nameFROM employeesWHERE commission_pct = (SELECT min(commission_pct ) FROM employees GROUP BY department_id); A. The GROUP BY clause is not required in the sub-queryB. A function cannot be used in a sub-query SELECT statementC. The single row sub-query gives multiple records

Consider the following SQL query: SELECT name FROM Customers WHERE date_registered > (SELECT MIN(date_registered) FROM Customers);OptionsThe names of customers who registered after the first registered customer. The names of customers who registered on the same date as the first registered customer.An error because the subquery returns multiple values.An error because the subquery is missing the FROM clause.

Evaluate this SQL statement:SELECT first_name, commissionFROM employeeWHERE commission =(SELECT commissionFROM employeeWHERE UPPER(first_name) = 'SCOTT');What would cause this statement to fail?Select one:a.There is more than one employee with the first name Scott.b.The FIRST_NAME values in the database are in lowercase.c.Scalar function is not allowed in Subquery.d.All the given optionse.Scott has a zero commission value.

Evaluate the SQL statement:SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal;A. The statement gives an error at line 1. B. The statement gives an error at line 6.C. The statement produces the employee name, salary, department ID, and maximum salary earned in the employee department for all departments that pay less salary than the maximum salary paid in the company.D. The statement produces the employee name, salary, department ID, and maximum salary earned in the employee department for all employees who earn less than the maximum salary in their department.

Select dept_name, dept_id, avg (salary)from instructorgroup by dept_name;This statement is erroneous because Avg(salary) should not be selecteddept_id is not used in group by clauseMisplaced group by clauseGroup by clause is not valid in this queryReview AnswerNext

Mr. John is the president of a company. Five managers report to him. All other employees report to these managers.Examine the code:SELECT employee.ename FROM emp employeeWHERE employee.empno NOT IN (SELECT manager.mgrFROM emp manager);The above statement returns no rows selected. as the result. Why?Select one:a.A NULL value is returned from the subquery.b.NOT IN operator is not allowed in subqueries.c.None of the employees has a manager.d.All employees have a manager.