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.

Which SQL statement produces an error? Select one:a.SELECT department_id, job_id, AVG(salary)FROM emp_dept_vuGROUP BY department_id, job_id;b.SELECT job_id, SUM(salary)FROM emp_dept_vuWHERE department_id IN (10,20)GROUP BY job_idHAVING SUM(salary) > 20000;c.None of the statements produce an error; all are valid. d.SELECT department_id, SUM(salary)FROM emp_dept_vuGROUP BY department_id;e.SELECT *FROM emp_dept_vu;

Which of the following queries will return the data for employees who belong to the department with the highest value of department ID.1 pointSELECT * FROM EMPLOYEES WHERE DEP_ID = ( SELECT MAX(DEPT_ID_DEP) FROM DEPARTMENTS ) SELECT * FROM EMPLOYEES WHERE DEPT_ID_DEP = MAX ( SELECT DEPT_ID_DEP FROM DEPARTMENTS )SELECT * FROM EMPLOYEES WHERE DEP_ID = ( SELECT DEPT_ID_DEP FROM DEPARTMENTS WHERE DEPT_ID_DEP IS MAX )SELECT * FROM EMPLOYEES WHERE DEP_ID = MAX(DEP_ID)

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

Review this SQL Statement: SELECT ename, emp_number, salary FROM employee WHERE dept_number = (SELECT dept_number FROM department WHERE location IN('CHICAGO','ATLANTA')); Why may this statement return an error?

Time left 0:18:35Question 1Not yet answeredMarked out of 1.00Flag questionTipsQuestion textWhich SQL statement produces an error? Select one:a.SELECT department_id, job_id, AVG(salary)FROM emp_dept_vuGROUP BY department_id, job_id;b.SELECT job_id, SUM(salary)FROM emp_dept_vuWHERE department_id IN (10,20)GROUP BY job_idHAVING SUM(salary) > 20000;c.None of the statements produce an error; all are valid. d.SELECT department_id, SUM(salary)FROM emp_dept_vuGROUP BY department_id;e.SELECT *FROM emp_dept_vu;Clear my choiceQuestion 2Not yet answeredMarked out of 1.00Flag questionTipsQuestion textWhich statements would execute successfully?Select one or more:a.SELECT student_name,SUM(subject1) FROM marks WHERE student_name LIKE 'R%'; b.SELECT SUM (subject1+subject2+subject3)FROM marksWHERE student_name IS NULLc.SELECT student_name,subject1 FROM marks WHERE subject1 > AVG(subject1); d.SELECT SUM (DISTINCT NVL(subject1,0)),MAX(subject1)FROM marksWHERE subject1 > subject2;Question 3Not yet answeredMarked out of 1.00Flag questionTipsQuestion textSELECT cust_city, COUNT(cust_last_name) FROM customersWHERE cust_credit_limit > 1000 GROUP BY cust_city HAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000;Which statement is true regarding the outcome of the above query? Select one:a.It executes successfully.b.It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.c.It returns an error because the BETWEEN operator cannot be used in the HAVING clause.d.It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column. e.Date functionsClear my choiceQuestion 4Not yet answeredMarked out of 1.00Flag questionTipsQuestion textConsider the below tables:Promotions TableColumn NameDatatypeConstraintPromo_idNumberPKPromo_nameVarchar Promo_begin_dateDate Promo_end_dateDate  Sales TableColumn NameDatatypeConstraintPromo_idNumberFKCust_idNumberFKTime_idDate  Customer TableColumn NameDatatypeConstraintcust_idNumberPKcust_nameVarchar The Below query will generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007.SELECT promo_name,cust_name FROM promotions p JOIN sales s ON(time_id BETWEEN promo_begin_date AND promo_end_date) JOIN customer c ON (s.cust_id = c.cust_id) AND time_id < '30-oct-2007'; Which statement is true regarding the above query? Select one:a.It produces an error because the join order of the tables is incorrect.b.It produces an error because equijoin and nonequijoin conditions cannot be used in the samec.It executes successfully but does not give the required result.d.It executes successfully and gives the required result.Clear my choiceQuestion 5Not yet answeredMarked out of 1.00Flag questionTipsQuestion textThe COMMISSION column shows the monthly commission earned by the employee. Emp_IdDept_IdCommission1105002201000310 410600530800630200710 820300   Which tasks would require sub queries or joins in order to be performed in a single step?Select one or more:a.Finding the number of employees who earn a commission that is higher than the average commission of the company b.Finding the total commission earned by the employees in department 10c.Listing the employees who earn the same amount of commission as employee 3d.Listing the departments whose average commission is more that 600 e.Listing the employees whose annual commission is more than 6000 f.Listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID