我不明白这段MySQL表示法，后来不知道如何在Postgresql中做到这一点

I have this MySQL query, and it works on a MySQL database, but not on a PostgreSQL one: I have this MySQL query, and it works on a MySQ