Emphasis Heading 1 Normal Subtitle Title Na Spacing HE REGIONS REGION ID REGION_NAME DEPARTMENTS DEPARTMENT ID DEPARTMENT NAME MANAGER_ID LOCATION_ID EMPLOYEES COUNTRIES JOBS COUNTRY ID COUNTRY NAME REGION O JOB_ID JOB_TITLE MIN SALARY MAX_SALARY EMPLOYEE 10 FIRST_NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_O LOCATIONS JOB HISTORY LOCATION D STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE -COUNTRY_ID EMPLOYEE 10 START-DATE END DATE JOB D DEPARTMENT_ID 3.a Write an SQL statement that will display Employee ID, Fullname, Hire date and Salary of all employees working for more than 10 years and cated in United States of America. Display the output in descending order based on salary. (5 Marks) 3.b Write an SQL statement that will display number of employees per department name whose salary is greater than the average salary of employee working in Purchasing Department. (5 Marks) 3. Write an SQL statement that will display Employee id, lastname, current salary and the new salary by adding 10% of the current salary of all employees working in Accounting Department and include to display the amount of increase in salary. (5 Marks) States) Focus