By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located...

By using this table answer this question in SQL :

1. Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table.  If an employee does not belong to a department, then their department number and department name should show as
   
   “N/A”
   
   and their department city should show up as
   “No City info Found”
   .
   MAKE SURE you have all the employees displayed including the employees who do not have a department.
   
   

Extracted text: JOB_HISTORY JOBS PF' EMPLOYEE_ID P' START_DATE * END_DATE JOB_ID DEPARTMENT_ID P JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY NUMBER (6) NUMBER (0) VARCHAR2 (10 BYTE) VARCHAR2 (35 BYTE) DATE DATE NUMBER (8) VARCHAR2 (10 BYTE) NUMBER (4) JOB_ID_PK O IDX_JOB_TITLE JHIST_EMP_ID_ST_DATE_PK O JHIST_JOB_IX JHIST_EMPLOYEE_IX O JHIST_DEPARTMENT_IX DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID NUMBER (4) VARCHAR2 (30 BYTE) F NUMBER (8) NUMBER (4) EMPLOYEES LOCATION_ID EMPLOYEE_ID FIRST_NAME * LAST NAME U' EMAIL NUMBER (6) VARCHAR2 (20 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (20 BYTE) DEPT_ID_PK DEPT_LOCATION_IX PHONE_NUMBER HIRE_DATE JOB_ID SALARY DATE VARCHAR2 (10 BYTE) LOCATIONS NUMBER (8.2) COMMISSION_PCT F MANAGER_ID F DEPARTMENT_ID NUMBER (2.2) NUMBER (8) NUMBER (4) LOCATION_ID STREET_ADDRESS POSTAL_CODE * CITY NUMBER (4) VARCHAR2 (40 BYTE) VARCHAR2 (12 BYTE) STATE_PROVINCE F VARCHAR2 (30 BYTE) VARCHAR2 (25 BYTE) CHAR (2 BYTE) EMP_EMAIL_UK EMP_EMP_ID_PK O EMP_DEPARTMENT_IX O EMP_JOB_IX O EMP_MANAGER_IX O EMP_NAME_IX O IDX SALARY COUNTRY_ID LOC_ID_PK O LOC_CITY_IX O LOC_STATE_PROVINCE_IX O LOC_COUNTRY_Ix Y-- EMP_DETAIL S_VIEW COUNTRIES NUMBER (6) VARCHAR2 (1O) EMPLOYEE_ID COUNTRY_ID CHAR (2 BYTE) JOB_ID MANAGER_ID DEPARTMENT_ID COUNTRY_NAME VARCHAR2 (40 BYTE) NUMBER (8) F REGION_ID NUMBER NUMBER (4) COUNTRY_C_ID_PK LOCATION_ID COUNTRY_ID FIRST_NAME LAST_NAME NUMBER (4) CHAR (2) VARCHAR2 (20) VARCHAR2 (25) NUMBER (8, 2) SALARY REGIONS COMMISSION_PCT DEPARTMENT_NAME VARCHAR2 (30) JOB_TITLE NUMBER (2, 2) P REGION_ID NUMBER VARCHAR2 (35) REGION_NAME VARCHAR2 (25 BYTE) VARCHAR2 (30) VARCHAR2 (25) VARCHAR2 (40) VARCHAR2 (25) CITY REG_ID_PK STATE_PROVINCE COUNTRY_NAME REGION_NAME