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
6 months agoBernadine
6 months agoKing
7 months agoBrandon
7 months agoSusana
7 months agoIsreal
7 months agoLorrie
7 months agoGlen
8 months agoDorethea
8 months agoEzekiel
8 months agoIola
8 months agoJaleesa
8 months agoCharlene
1 year agoLorriane
1 year agoIluminada
1 year agoCletus
1 year agoEleonore
1 year agoKayleigh
12 months agoKerry
12 months agoElvis
1 year agoJudy
1 year agoDong
1 year agoJosefa
1 year agoFallon
1 year agoMelvin
1 year agoAmina
1 year agoJeanice
1 year agoMona
1 year agoAlise
1 year agoCathrine
1 year agoMyra
1 year agoMabel
1 year ago