Question: jump to level 1 table [ [ Job , Date,Location ] , [ - JoblD, - DatelD, - LocationID ] , [ Title ,

jump to level 1
\table[[Job,Date,Location],[- JoblD,- DatelD,- LocationID],[Title,FullDate,StreetAddress],[JobCode,DayNumber,City],[LevelCode,MonthNumber,PostalCode],[,\table[[MonthName],[Year]],\table[[State],[CountryCode]]]]
EmployeeFact
(cEmployeeID
o JoblD
OLocationID
OHireDatelD
BirthDatelD)
SalaryAmount
BonusAmount
EducationYears
PerformanceRating
The following query reports the postal code with the highest bonus amount for employees with level code 9. Complete the missing values.
SEIECT PostalCode, MAX
(A)
FROM
(B)
Location, Job
WHERE EmployeeFact. LocationID = Location. LocationID
AND EmployeeFact.JobID =
(C)
AND
(D)
=9
(E)
BY
(F)
(D)
(A)
(E)
(C)
(F)
 jump to level 1 \table[[Job,Date,Location],[- JoblD,- DatelD,- LocationID],[Title,FullDate,StreetAddress],[JobCode,DayNumber,City],[LevelCode,MonthNumber,PostalCode],[,\table[[MonthName],[Year]],\table[[State],[CountryCode]]]] EmployeeFact (cEmployeeID o

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!