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 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.

Oracle SQL Developer File Edit View N Connections Columns Data TMC COUNTRIES Act CUSTOMER COLUMN DEPARTMENTS 1 EMPLOYEE DEPARTMENT ID 2 FIRST NAN E DEPARTMENT NAME 3 LAST NAM MANAGER ID LOCATION ID 4 EMAIL DOCNO 5 PHONE NU EMPLOYEES 6 HIRE DAT EMPLOYEE ID 7 JOB ID FIRST NAME 8 SALARY LAST NAME 9 COMMISSI EMAIL 10 MANAGER PHONE NUMBER HIRE DATE 11 DEPARTMEI E JOB ID EE SALARY COMMISSION PCT MANAGER ID DEPARTMENT ID INVENTORY IEEE ITEM Reports