I would say it's better to do the actual task and create a view instead of trying to get around the proper task. It's stupid to exercise and not do it properly.
You need order the results ascending and then it works because the expected results are ordered as well. It shouldn't be like this cuz there is nothing about ordering the results in the instructions
The answer is below...
I would say it's better to do the actual task and create a view instead of trying to get around the proper task. It's stupid to exercise and not do it properly.
You need order the results ascending and then it works because the expected results are ordered as well. It shouldn't be like this cuz there is nothing about ordering the results in the instructions
Oh snap, I read it totally differently, now I see the point.
This comment is hidden because it contains spoiler information about the solution
In version 2, don't forget to wrap the whole field when converting to a float..
e.g.
(trunc(SUM(J.salary)*100)/100)::floatDeleted the semicolon and it works. Semicolons are really a powerful weapons in CodeWars. :P
Every value rounded to 2 decimals and still not passing the test. What's going on? :(
Same here, every value rounded to 2 decimals and still not passing the round test. :/