Does that query work directly on your MySQL server? I’m guessing it’s complaining about some syntax problem, but MySQL is sadly not very helpful with it’s errors.
The error comes from your MySQL database, not Metabase.
I ran it on Metabase actually. Does Metabase support row_number() function?
@jupiter What you input in the editor is send to your database. What functions it support depends on the database and version, not Metabase.