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.

Transcribed Image Text:

Oracle SQL Developer Connections 3- COUNTRIES CUSTOMER DEPARTMENTS Ja pa SO DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID DOCNO EMPLOYEES Reports EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID INVENTORY ITEM File Edit View M SOL N EOL Felix x EN Columns Data | Mo Act COLUMM 1 EMPLOYEE 2 FIRST NA 3 LAST_NAM 4 EMAIL 5 PHONE NU 6 HIRE_DAT 7 JOB_ID 8 SALARY 9 COMMISSI 10 MANAGER 11 DEPARTME Oracle SQL Developer Connections 3- COUNTRIES CUSTOMER DEPARTMENTS Ja pa SO DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID DOCNO EMPLOYEES Reports EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID INVENTORY ITEM File Edit View M SOL N EOL Felix x EN Columns Data | Mo Act COLUMM 1 EMPLOYEE 2 FIRST NA 3 LAST_NAM 4 EMAIL 5 PHONE NU 6 HIRE_DAT 7 JOB_ID 8 SALARY 9 COMMISSI 10 MANAGER 11 DEPARTME

Answer rating: 100% (QA)

Solution CREATE TABLE EMPLOYEES EMPLOYEEID varCHAR7 Primary Key ... View the full answer