I would of course love to solve in python as well, however it seems to me that time has passed. This kata is practically 10 years old and now IMHO, it is not 1kuy. Maybe you should just do something based on this task, but heavily refined (I mean a completely new publication)? For example, make it a performance task, add: JOIN, LEFT JOIN, RIGHT JOIN, DISTINCT, CASE, EXISTS.... These are just as examples of what could be implemented and improve this kata.

By the way as a performance option, if there will be large data volumes and different sized tables, the right JOIN will make a difference. If you do it nicely and add significant differences from this kata, I think it would be a great new kata.

p.s. I wonder if anyone has responded on Discord though? What kind of response did you get?

You certainly picked an ambitious target for your first translation. I'd suggest getting a thorough review from someone proficient in writing kata in Python, i.e. not me.

Probably needs forking; the description was changed for below solved issue.

what about the random tests?