Table Name Column Names REGIONS REGION ID, REGION NAME COUNTRIES COUNTRY_ID, COUNTRY_ NAME, REGION_ID LOCATIONS LOCATION ID, STREET ADDRESS, POSTAL CODE, CITY, STATE PROVINCE, COUNTRY ID DEPARTMENTS...


Table Name<br>Column Names<br>REGIONS<br>REGION ID, REGION NAME<br>COUNTRIES<br>COUNTRY_ID, COUNTRY_ NAME, REGION_ID<br>LOCATIONS<br>LOCATION ID, STREET ADDRESS, POSTAL CODE, CITY,<br>STATE PROVINCE, COUNTRY ID<br>DEPARTMENTS<br>DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,<br>LOCATION ID<br>EMPLOYEES<br>ΕMPLOYEE D, FIRST NΑΜΕ, LAST NAMΕ, EΜAL ,<br>PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY,<br>COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID<br>JOB HISTORY<br>EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID,<br>DEPARΤΜΕNT ID<br>JOBS<br>JOB ID, JOB TITLE, MIN SALARY, MAX SALARY<br>

Extracted text: Table Name Column Names REGIONS REGION ID, REGION NAME COUNTRIES COUNTRY_ID, COUNTRY_ NAME, REGION_ID LOCATIONS LOCATION ID, STREET ADDRESS, POSTAL CODE, CITY, STATE PROVINCE, COUNTRY ID DEPARTMENTS DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION ID EMPLOYEES ΕMPLOYEE D, FIRST NΑΜΕ, LAST NAMΕ, EΜAL , PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID JOB HISTORY EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARΤΜΕNT ID JOBS JOB ID, JOB TITLE, MIN SALARY, MAX SALARY
1. Find out each manager's work address. Note that a manager's work address is the same as the address of<br>the department which s/he manages.<br>• Address Format: Street_Address<COMMA><SPACE>Postal_Code<COMMA><br><SPACE>City<COMMA><SPACE>Country_Name<br>• Write query in oracle sql.<br>

Extracted text: 1. Find out each manager's work address. Note that a manager's work address is the same as the address of the department which s/he manages. • Address Format: Street_AddressPostal_Code CityCountry_Name • Write query in oracle sql.

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here