Name (PRINT): 11/09/2017 REGIONS REGION 10 REGION_NAME DEPARTMENTS DEPARTMENT_ID = DEPARTMENT NAME MANAGER_O + LOCATION_O COUNTRIES COUNTRY_ID COUNTRY_NAME REGION_ID JOBS Joa 10- JOB TITLE MIN_SALARY MAX GALLARY EMPLOYEES EMPLOYEE IN FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JDED SALARY COMMISSION_PCT MANAGER_in +DEPARTMENT_ID LOCATIONS LOCATION_ID STREET_ADDRESS POSTA_ccoE ITY STATE_PROVINCE +COUNTRY_ID JOB_HISTORY EMPLOYEE_ID START-DATE FND_LATE JOB ID DEPARTMENT_0 Answer app questions. Write clearly. 1. Select first name, last name and email address of the employees where commission percentage is null and making more than $30000 and working in department 50. 2. Insert a new employee into employees with all the required details. 3. Delete all employees working as "SALES_REP in department 30 making no commission. 4. Increase the salary of all employees by 30% if the employee is making some commission and the job_id is "SALES REP". 5. Insert a row into employee table with manager id 110 and department 70. 6. Show department name and manager first and last name. 7. Display department name, manager name, and city. 8. Show country name, city, region name and department name all department from London and Tokyo. 9. Create the employee table. 10. Show details of current job for employees who worked as IT Programmers in the past