.h regards t0 +he tables Countrie abs follów quer gd Ennployees write out the Th
ID: 3739558 • Letter: #
Question
.h regards t0 +he tables Countrie abs follów quer gd Ennployees write out the The Following Tables AND complete as many questions as possiale. 1. Show all Job_Titles for Employees in Australia 2. Where is the Highest Paid Worker From? 3. How many people are UNDER payed based on untrie COUNTRY NAME United States of America 4 REGION D US GY Germany Min_Salary ?(Show Names, Employee ID, and Country Name) Jobs 4. Average Salary for a. Custodians b. Clerical c. Data Scientists d. VP's OB TITLE Min SALARY CUSTODIAN CLERICAL Data Scientislt Executive Vice President 200000 200 10000 Employees 5. Average total Salary amongst all employees EMPLOYtt-D-Traust NAME-.- 825571 n685i 87490 LAST-NAME-.JO -O- SALARY REGION-ID CARN US POPULExplanation / Answer
1. SELECT JOB_TITLE FROM JOB WHERE JOB_ID IN ( SELECT JOB_ID FROM EMPLOYEES WHERE
REGION_ID IN (SELECT DISTINCT REGION_ID FROM COUNTRY WHERE COUNTRY_NAME = 'AUSTRALIA' ;
2. SELECT COUNTRY_NAME FROM COUNTRIES WHERE REGIEN_ID (SELECT REGIN_ID FROM EMPLOYEES WHERE JOB_ID IN ( SELECT JOB_ID FROM JOBS WHERE MIN_SALARY = MAX (SALARY) ;
3. SELECT COUNT (EMPLOYEE_ID , FIRST_NAME , COUNTRY_NAME ) FROM CASE WHEN MIN_SALARY<=(SELECT AVG(SALARY) FROM EMPLOYEEES;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.