Name:Unknown
Clan:Unknown
Member Since:Oct 2019
Last Seen:Dec 2021
Profiles:
Following:0
Followers:0
Allies:0
Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
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. :/