Question 5). Answer the questions according to following tables: EMPLOYEES NAME JOHN MARY ROBERT SUSAN HARRY SURNAME SALARY DEPARTMENT ENTRY YEAR PAUL 5000 ACCOUNTING 1998 SMITH 9600 HEAD QUARTER 2000 HOPKINS 4500 PRODUCTION 2001 MILLER 7000 IT 1998 BROWN 9500 IT 1999 a) By Using an appropriate SQL Aggregate function and GROUP BY statement, classify the Total amount of SALARY paid in each DEPARTMENT (7 Points) DEPARTMENTS NAME LOCATION ACCOUNTING LONDON HEAD QUARTER (LONDON PRODUCTION CARDIFF IT LEEDS b) By Using a Nested Query on EMPLOYEES, Show NAMEs and SURNAMES of EMPLOYEES who are earning more than AVERAGE SALARIES. (7 Points) c) By JOINING two tables with SQL Statement, show the NAMEs of the EMPLOYEES who are working in LONDON (in DEPARTMENTS) (6 Points)