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
3 months agoBernadine
3 months agoKing
4 months agoBrandon
4 months agoSusana
4 months agoIsreal
4 months agoLorrie
4 months agoGlen
5 months agoDorethea
5 months agoEzekiel
5 months agoIola
5 months agoJaleesa
5 months agoCharlene
10 months agoLorriane
9 months agoIluminada
9 months agoCletus
10 months agoEleonore
10 months agoKayleigh
9 months agoKerry
9 months agoElvis
10 months agoJudy
10 months agoDong
10 months agoJosefa
10 months agoFallon
10 months agoMelvin
11 months agoAmina
11 months agoJeanice
9 months agoMona
10 months agoAlise
10 months agoCathrine
10 months agoMyra
11 months agoMabel
11 months ago