from billion variations i see solution without unrequired minmaxes (as well as mine).

in my opinion it is the best option

Actually nope, as here there's a remainder operator used, and not the division one.
So, if a number is even, its remainder divided by two is zero, thus it should go to the "else"(after : here) part.

Good one buddy

nice

Ah yes! I also used this basic solution but you brought it down one more level. This is nice.

pretty advanced solution for 7kyu kata
nicely done

nice job

Oh, I see now, I think it just seems clear enough for me, but I guess, you're right, your code is more clear. Thanks for pointing it out!

I understand that the result is the same, my question is why would you choose a more confusing syntax.

i.e. a-b+c is naturally clearer than -b+c+a

I'm sorry, I don't understand your question, It's just different order of addends, the result is the same.

The equivalent solutions in upper case and lower case in SQL are not grouped together but should be.

nice

Can anyone explain how the date functions work? Thanks