I am novice and have a dumb question - where can I find all the basic functions of SQL?

Veru good challenge. The instructions were clear and it was a good way to practice working with different dtypes and converting them accordingly. Thank you!

Agree with jwilly5.
Eventually figured out why there was some nonsense error that _0.308 -> 0.308.
But bottom line someone can and should be able to use to_char here and because the kata is the way it is that doesn't work.
It's a problem with a lot of the SQL kata on Codewars I'm noticing - just needless little nitpicky errors prevent completion

TRIM(to_char(cast(hits as float) / cast(at_bats as float), '0.999')) as batting_average

^^^^^^
This worked for me, although it looks sloppy

Not an issue

good challenge for sports lovers

I agree

My code works but there is a rounding problem. Some of of my answers are a thousandth lower than expected. What to do ?

I have no idea. This kata is so weird... I feel like maybe codewars have better problems in other languages and not SQL