A

Subject:Computer SciencePrice:3.87 Bought7

Share With

A. Display employee number, employee full name, phone, extension, and country for employees who work in Japan and UK. Sort the result based on the employee number.

B. Modify the query in Question 1 part A to display the manager ID and the manager name for the employees returned by the previous query.

 

( for more questions about the data base ill include an imgur link of the lab before this lab that has a picture of the ERD for the database this question is using. Please use syntax that would work in Oracle SQL developer not SQL server.

 

IMGUR LINK: https://imgur.com/a/BU2US2F

The tables are called Employee and Office

Office

OFFICECODE

CITY

PHONE

ADDRESSLINE1

ADDRESSLINE2

STATE

COUNTRY

POSTALCODE

TERRITORY

Employee

EMPLOYEENUMBER

LASTNAME

FIRSTNAME

EXTENSION

EMAIL

OFFICECODE

REPORTSTO

JOBTITLE