My kata passes when I test it but it fails on the attempt.Does anyone have any idea why?
This is the error that I get :
expected: [{:average_salary=>98677.2, :job_title=>"engineer", :total_people=>1, :total_salary=>98677.2}, {:aver...1}, {:average_salary=>10252.36, :job_title=>"economist", :total_people=>1, :total_salary=>10252.36}]
got: [{:average_salary=>82058.12, :job_title=>"lifeguard", :total_people=>4, :total_salary=>328232.49}, {:...1}, {:average_salary=>10252.36, :job_title=>"economist", :total_people=>1, :total_salary=>10252.36}]

I used DENSE RANK function instead of RANK() and it passed. Is there a difference between them ?

Thanks :)

Will someone please explain the difference between CONCAT() and the CONCAT_WS() function?