By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank from (select 1 as foo, 2 as profit) x(x, profit)' at line 1
| x | profit | profit_rank |
|---|---|---|
| 1 | 2 | 1 |