It looks like in this particular case JOIN isn't necessary at all. Therefore either the assignment should be changed to justify the JOIN or Kata should be renamed.
I'm confused over what the 1 fail I got "Your character count: 257 Value is not what was expected." And I don't know how to approach solving this. I've deleted characters but it doesn't really make a difference.
well timmy's not perfect and this is a bug fixing kata so you're not required to change much.
It looks like in this particular case JOIN isn't necessary at all. Therefore either the assignment should be changed to justify the JOIN or Kata should be renamed.
you need to
COUNT
the people properly.round the
average_salary
andtotal_salary
to 2 decimal placesand
ORDER BY
theaverage_salary
decending.This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
May you please post your solution here and mark it as a spoiler (so I can provide you with the necessary hints)? Thank you :)
I'm confused over what the 1 fail I got "Your character count: 257 Value is not what was expected." And I don't know how to approach solving this. I've deleted characters but it doesn't really make a difference.