- Database Hr Tables Regions Region Id Region Name 1 Europe 2 3 Countries Ar Au Be Us Ca Country Id Country Name Region 1 (194.36 KiB) Viewed 54 times
You need to include the following columns in yourresult:
- Database Hr Tables Regions Region Id Region Name 1 Europe 2 3 Countries Ar Au Be Us Ca Country Id Country Name Region 2 (20.07 KiB) Viewed 54 times
***Only correct and accurate answersplease
***Understand the above given database beforeanswering the questions
Subject is Database Programming (SQL)
Database: HR, Tables: Regions Region ID Region Name 1 Europe 2 3 Countries AR AU BE US CA Country ID Country Name Region_ID Argentina Australia Belgium USA Canada CH CN DE DK EG FR Americas IL Asia Middle East and 4 Africa Switzerland China Germany Denmark Egypt France Israel 2 3 1 2 2 1 3 1 1 4 1 4 Location_id Street Address 1000 1100 1200 1300 1400 1500 1600 1700 1297 Via Cola di Rie 93091 Calle della Testa 2017 Shinjuku-ku 9450 Kamiya-cho 2014 Jabberwocky Rd 2011 Interiors Blvd 2007 Zagora St 2004 Charade Rd 1800 1900 2000 40-5-12 Laogianggen 2100 1298 Vileparle (E) 2200 12-98 Victoria Street 2300 198 Clementi North 147 Spadina Ave 6092 Boxwood St Locations 2400 8204 Arthur St 2500 Magdalen Centre, The Oxford Science Park 2600 9702 Chester Road Schwanthalerstr. 7031 2700 2800 Rua Frei Caneca 1360 2900 20 Rue des Corps-Saints 3000 Murtenstrasse 921 3100 Pieter Breughelstraat 837 3200 Mariano Escobedo 9991 Postal Code City 989 Roma 10934 Venice 1689 Tokyo 6823 Hiroshima 26192 99236 50090 98199 Southlake South San Francisco South Brunswick Seattle Toronto Whitehorse 190518 Beijing 490231 Bombay 2901 Sydney 540198 Singapore London Oxford Stretford Munich Sao Paulo Geneva Bern Utrecht Mexico City M5V 2L7 YSW 9T2 OX9 9ZB 9629850293 80925 01307-002 1730 3095 3029SK 11932 State Province Tokyo Prefecture Texas California New Jersey Washington Ontario Yukon Maharashtra New South Wales Oxford Manchester Bavaria Sao Paulo Geneve BE Utrecht Distrito Federal, Country_ID IT IT JP JP US US US US CA CA CN IN AU SG UK UK UK DE BR CH CH NL MX
Departments DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10 Administration 20 Marketing 30 Purchasing 40 Human Resources 50 60 80 70 Public Relations 90 200 210 Shipping 100 Finance 110 Accounting 120 Treasury 130 Corporate Tax 140 Control And Credit 150 Shareholder Services 160 Benefits IT 170 Manufacturing 180 Construction 190 Contracting Operations IT Support 230 240 Sales 250 260 Executive 220 NOC IT Helpdesk Government Sales Retail Sales Recruiting 200 201 114 203 121 103 204 145 100 108 205 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1700 1800 1700 2400 1500 1400 2700 2500 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 Jobs Job_ID AD PRES AD_VP FI ACCOUNT FI_MGR IT PROG Job Title President Administration Vice President Accountant Finance Manager Programmer Min_Salary 20080 15000 4200 8200 4000 Max Salary 40000 30000 9000 16000 10000
Employees SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID 24000.00 0.00 17000.00 0.00 Ernst EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID King SKING 515.123.4567 2003-06-17 AD_PRES Kochhar NKOCHHAR 515.123.4568 2005-09-21 AD_VP De Haan LDEHAAN 515.123.4569 2001-01-13 AD_VP 17000.00 0.00 Hunold AHUNOLD 590.423.4567 2006-01-03 IT_PROG 9000.00 0.00 BERNST 590.423.4568 2007-05-21 IT PROG 6000.00 0.00 DAUSTIN 590.423.4569 2005-06-25 IT PROG 4800.00 0.00 VPATABAL 590.423.4560 2006-02-05 IT_PROG 4800.00 0.00 Lorentz DLORENTZ 590.423.5567 2007-02-07 IT_PROG 4200.00 0.00 Greenberg NGREENBE 515.124.4569 2002-08-17 FI MGR 12008.00 0.00 Faviet DFAVIET 515.124.4169 2002-08-16 FI_ACCOUNT 9000.00 0.00 JCHEN 515.124.4269 2005-09-28 FI_ACCOUNT 8200.00 0.00 ISCIARRA 515.124.4369 2005-09-30 FI ACCOUNT 7700.00 0.00 Austin Pataballa Chen Sciarra 100 101 102 103 104 105 106 107 108 109 110 111 Steven Neena Lex Alexander Bruce David Valli Diana Nancy Daniel John Ismael 0 100 100 102 103 103 103 103 101 108 108 108 90 90 90 60 60 60 60 60 100 100 100 100
EMPLOYEE ID FirstLevelManagerFirstName EmployeeLastName EmployeeFirstName Second LevelManagerID SecondLevelManagerLastName FirstLevelManagerID FirstLevelManagerLastName SecondLevelManagerFirstName ThirdLevelManagerlD