DEPARTMENT DegDe 10 ACCOUNTING 30 RESLAROU 10 SALES 40 OPERATIONS Low MTW YOR DALLAS CAGO BOSTON IM SO EMPLOYEE Emp.no Nene 7 KINO 7565 BONES SCOTT 7830 ADAMS 902 FORD 700 SMITH BLAKE ALLEN 7521 WARD 7654 MARTIN 7844 TURNER 7900 JAMES 17782 CLARK 0 co O 0 0 PREVENTING MANAGER LANALYSE CLER 2730 ANALYST CLERK MANAGER SALESMANN SALESMAN MALESMAN MILESMAN CLERK MANAGER 18012 1982-12.00 1183-01-12 1902-12-05 10-11-12 1801-05-21 100 11-02-22 11100 191000 11-12-03 11-06-09 00 1100 1000 100 2050 1600 120 1 1500 0 2450 Duplo 10 30 20 20 30 20 10 SO 30 30 30 100 100 1000 210 0 10 Resume that you are required to write a query that is the name of each department and the number of employees whose salary is greater than the average salary of all employees Which of the following queries would you select to retrieve the required information? 61 8 0 Y U P FI G9 Hi J KL Consider the following two tables DEPARTMENT Dept no Dept name 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS Location NEW YORK DALLAS CHICAGO DOSTON Job ololololo CLERK EMPLOYEE Emp no Name 7839 KING 7566 JONES 7788 SCOTT 7876 ADAMS 7902 FORD 7369 SMITH 7698 BLAKE 7499 ALLEN 7521 WARD 7654 MARTIN 7844 TURNER JAMES 7782 CLARK Boss PRESIDENT NULL MANAGER 7839 ANALYST 7566 7788 ANALYST 7566 CLERK 7902 MANAGER 7839 SALESMAN 7699 SALESMAN 7698 SALESMAN 7698 SALESMAN 7698 CLERK 7698 MANAGER 7839 Hiredete 1981-11-17 1981-04-02 1982-12-09 1983-01-12 1981-12-03 1980-12-17 1981-05-01 1981-02-20 1981-02-22 1981-09-26 1981-09-08 1981-12-03 1981-06-09 Selny 5000 2975 3000 1100 3000 800 2850 1600 22:50 12:50 1500 950 2450 Bonus Dept. 10 20 20 20 20 0 20 O 30 300 30 500 30 1400 30 250 30 30 O 10 7900 Assume that you are required to write a query that lists the name of each department and the number of employees whose salary is greater than the average salary of all employers. Which of the following queries would you select to retrieve the required information? % 5 & 7 E 6 8 0 3 . Y U ok E G DEPARTMENT DegDe 10 ACCOUNTING 30 RESLAROU 10 SALES 40 OPERATIONS Low MTW YOR DALLAS CAGO BOSTON IM SO EMPLOYEE Emp.no Nene 7 KINO 7565 BONES SCOTT 7830 ADAMS 902 FORD 700 SMITH BLAKE ALLEN 7521 WARD 7654 MARTIN 7844 TURNER 7900 JAMES 17782 CLARK 0 co O 0 0 PREVENTING MANAGER LANALYSE CLER 2730 ANALYST CLERK MANAGER SALESMANN SALESMAN MALESMAN MILESMAN CLERK MANAGER 18012 1982-12.00 1183-01-12 1902-12-05 10-11-12 1801-05-21 100 11-02-22 11100 191000 11-12-03 11-06-09 00 1100 1000 100 2050 1600 120 1 1500 0 2450 Duplo 10 30 20 20 30 20 10 SO 30 30 30 100 100 1000 210 0 10 Resume that you are required to write a query that is the name of each department and the number of employees whose salary is greater than the average salary of all employees Which of the following queries would you select to retrieve the required information? 61 8 0 Y U P FI G9 Hi J KL Consider the following two tables DEPARTMENT Dept no Dept name 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS Location NEW YORK DALLAS CHICAGO DOSTON Job ololololo CLERK EMPLOYEE Emp no Name 7839 KING 7566 JONES 7788 SCOTT 7876 ADAMS 7902 FORD 7369 SMITH 7698 BLAKE 7499 ALLEN 7521 WARD 7654 MARTIN 7844 TURNER JAMES 7782 CLARK Boss PRESIDENT NULL MANAGER 7839 ANALYST 7566 7788 ANALYST 7566 CLERK 7902 MANAGER 7839 SALESMAN 7699 SALESMAN 7698 SALESMAN 7698 SALESMAN 7698 CLERK 7698 MANAGER 7839 Hiredete 1981-11-17 1981-04-02 1982-12-09 1983-01-12 1981-12-03 1980-12-17 1981-05-01 1981-02-20 1981-02-22 1981-09-26 1981-09-08 1981-12-03 1981-06-09 Selny 5000 2975 3000 1100 3000 800 2850 1600 22:50 12:50 1500 950 2450 Bonus Dept. 10 20 20 20 20 0 20 O 30 300 30 500 30 1400 30 250 30 30 O 10 7900 Assume that you are required to write a query that lists the name of each department and the number of employees whose salary is greater than the average salary of all employers. Which of the following queries would you select to retrieve the required information? % 5 & 7 E 6 8 0 3 . Y U ok E G