1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of TWENTY-FOURTH of Mar, 1998, TUE with the column name BornDate and by extracting job_id string from the 4th position with three (3) determined length with the column name JobType, whose end_date greater than '31-Dec-1998' or should not have 'ing' at the end of department_name column. Arrange the output on department_id from highest to lowest. [6 Marks] 1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of TWENTY-FOURTH of Mar, 1998, TUE with the column name BornDate and by extracting job_id string from the 4th position with three (3) determined length with the column name JobType, whose end_date greater than '31-Dec-1998' or should not have 'ing' at the end of department_name column. Arrange the output on department_id from highest to lowest. [6 Marks] 1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of TWENTY-FOURTH of Mar, 1998, TUE with the column name BornDate and by extracting job_id string from the 4th position with three (3) determined length with the column name JobType, whose end_date greater than '31-Dec-1998' or should not have 'ing' at the end of department_name column. Arrange the output on department_id from highest to lowest. [6 Marks] 1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of TWENTY-FOURTH of Mar, 1998, TUE with the column name BornDate and by extracting job_id string from the 4th position with three (3) determined length with the column name JobType, whose end_date greater than '31-Dec-1998' or should not have 'ing' at the end of department_name column. Arrange the output on department_id from highest to lowest. [6 Marks]