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.
Avoid reinventing the wheel ;-)
I don't know how it possible, but order of actions here is really important - I firstly misread description and put sub ahead of add and get tons of errors; after switching their places in program all test cases were passed. But mathematically these two actions can be done without a specific order, am I wrong?
From initial code:
I works with simple WITH tables... but it can be buggy in case where some items won't have any good/ok/bad scores
I don't really get why this kata named '...JOIN'
I advice you do not forget about leap year when getting number of full years by dividing (number_of_days by 365.25 instead of 365)
What is the name of a table in SQL part?
Treat newline characters as any other character that is not a space.
Excuse me, what should I do with '\n's?
There is no hint about it in description. As I understand it neither shifting like other symbols (because result for multilined strings is differs from single-lined), nor temporately saved like position of blanks (because initial and result strings don't match each other in both number of symbols in each line and number of words in each line)
It was said in describtion that list of integers could be VERY long, so it's practically to find in first 3 digits which more - odds or evens - and later look for for only one odd/even number and imidiately break after finding such digit. If you have 999999999 odd numbers and only one even in position № 7 for example. So, you can economy tremendous amount of machine resourses