I've got a good feeling about option B. Grouping by both dept_id and salary seems like it could give me the average of the max salaries per department.
Okay, I got this. The compensation philosophy is all about the company's overall approach and principles when it comes to employee pay. I think option D captures that the best - it's about the guiding principles behind the compensation programs.
Lashaunda
5 months agoBernadine
5 months agoKing
5 months agoBrandon
5 months agoSusana
6 months agoIsreal
6 months agoLorrie
6 months agoGlen
6 months agoDorethea
6 months agoEzekiel
6 months agoIola
6 months agoJaleesa
6 months agoCharlene
11 months agoLorriane
11 months agoIluminada
11 months agoCletus
11 months agoEleonore
11 months agoKayleigh
10 months agoKerry
10 months agoElvis
11 months agoJudy
12 months agoDong
11 months agoJosefa
11 months agoFallon
12 months agoMelvin
1 year agoAmina
1 year agoJeanice
11 months agoMona
11 months agoAlise
11 months agoCathrine
12 months agoMyra
1 year agoMabel
1 year ago