If you ignore the variable naming and really crammed and unreadable one-liners, then sure.

+1 I am grateful to have been able to get through a solution based on various resources, but I can't say that I fully grasp the LATERAL functionality. Exciting to continue pursuing this concept!

The Python version is working fine now.

It doesn't matter what this function does, as you don't require to substitute it with your own function.

thank you

What is a handler?

I solved it by reading the example tests. That's everything you need to read. Just ignore the description.

Answer to this question will give away the solution.

use fraction or decimal module

It also should specify you are not able to use ORDER.

If you dont use the VALUES command, the order will default as alphabetical.
Rightly or wrongly, you can submit the problem in alphabetical ordered columns, not in the order shown in the expected.
I'll leave the rest for you to take it from there.

Well, there is a solution to this, which, I admit, I had to find on StackOverflow.

( https://stackoverflow.com/questions/47273373/postgres-crosstab-allocating-values-to-wrong-columns ) - I have implemented it in one of my solutions.

You can use VALUES command as second parameter of crosstab() function to specify an arbitrary column order, see section no. F.38.1.4 in the PostgreSQL 9.6 documentation.

Me too. And I cannot use "With ... AS ()" subquery to escape the single quote, it will tell me the table not exists.

https://www.youtube.com/watch?v=QQT8e9aewV0 <- My solution is similar to how this guy explained it. (honestly i got inspired from this tutorial)
https://stackoverflow.com/questions/28550679/what-is-the-difference-between-lateral-and-a-subquery-in-postgresql <- best explanation that I found so far about it.

same issue with python3.7