It seems to me that the generated data is seriously hampering this Kata. I actually passed the test by lowering the minimum required price to 9 times lower what it was required. And even then, I had to run the code about 5 times before it worked.

I would always get get everything correct, but then I would get this "undefined method `keys' for nil:NilClass
Simplified backtrace: block (3 levels) in " error, which as far as I read from comments, it's because one of the columns got no data back from the generated data table.

Is there a way not to hardcode this? Maybe a function like next_column or something similar?

Agreed. It only worked with one of the two, and that should be better specified.

Maybe I'm not that experience, but by trying to use the actual command mentioned in the Kata, I would've never completed it.

I noticed some solutions don't quite hit the "atbats" condition correctly. Maybe add some extra rows to "make or break" a solution based on that, actually selecting the wrong amount of rows if the condition isn't set up properly?

I wonder though, I transformed both values to be able to get the result I wanted. Though seeing some other codes, people only really converted one value. Why is that?

I got caught a bit off guard by the casting, since I've never used them on an PL/SQL query, but the exercise in itself was cool.

Somewhat complex looking Kata with simple solution. Very nice!