The HR$\_$JOB$\_$HISTORY table stores job history of the employees. If an employee changes departments within the job or changes jobs within the department, new rows get inserted into this table with old job information of the employee. Create a query that will show the concatenated first and last name of all employees in the HR$.$JOB$\_$HISTORY table along with their old job title and old department name and their new job title and new department name.Here are the TABLES: $--------------------------------------------------------$

$--$ DDL for Table HR$\_$COUNTRIES

$--------------------------------------------------------$

CREATE TABLE HR$\_$COUNTRIES

$($ COUNTRY$\_$ID CHAR$(2),$

COUNTRY$\_$NAME VARCHAR$2(40),$

REGION$\_$ID NUMBER

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$DEPARTMENTS

$--------------------------------------------------------$

CREATE TABLE HR$\_$DEPARTMENTS

$($ DEPARTMENT$\_$ID NUMBER$(4,0),$

DEPARTMENT$\_$NAME VARCHAR$2(30),$

MANAGER$\_$ID NUMBER$(6,0),$

LOCATION$\_$ID NUMBER$(4,0)$

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$EMPLOYEES

$--------------------------------------------------------$

CREATE TABLE HR$\_$EMPLOYEES

$($ EMPLOYEE$\_$ID NUMBER$(6,0),$

FIRST$\_$NAME VARCHAR$2(20),$

LAST$\_$NAME VARCHAR$2(25),$

EMAIL VARCHAR$2(25),$

PHONE$\_$NUMBER VARCHAR$2(20),$

HIRE$\_$DATE DATE,

JOB$\_$ID VARCHAR$2(10),$

SALARY NUMBER$(8,2),$

COMMISSION$\_$PCT NUMBER$(2,2),$

MANAGER$\_$ID NUMBER$(6,0),$

DEPARTMENT$\_$ID NUMBER$(4,0)$

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$JOBS

$--------------------------------------------------------$

CREATE TABLE HR$\_$JOBS

$($ JOB$\_$ID VARCHAR$2(10),$

JOB$\_$TITLE VARCHAR$2(35),$

MIN$\_$SALARY NUMBER$(6,0),$

MAX$\_$SALARY NUMBER$(6,0)$

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$JOB$\_$HISTORY

$--------------------------------------------------------$

CREATE TABLE HR$\_$JOB$\_$HISTORY

$($ EMPLOYEE$\_$ID NUMBER$(6,0),$

START$\_$DATE DATE,

END$\_$DATE DATE,

JOB$\_$ID VARCHAR$2(10),$

DEPARTMENT$\_$ID NUMBER$(4,0)$

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$LOCATIONS

$--------------------------------------------------------$

CREATE TABLE HR$\_$LOCATIONS

$($ LOCATION$\_$ID NUMBER$(4,0),$

STREET$\_$ADDRESS VARCHAR$2(40),$

POSTAL$\_$CODE VARCHAR$2(12),$

CITY VARCHAR$2(30),$

STATE$\_$PROVINCE VARCHAR$2(25),$

COUNTRY$\_$ID CHAR$(2)$

$)$;

$--------------------------------------------------------$

$--$ DDL for Table HR$\_$REGIONS

$--------------------------------------------------------$

CREATE TABLE HR$\_$REGIONS

$($ REGION$\_$ID NUMBER,

REGION$\_$NAME VARCHAR$2(25)$

$)$;