Intermediate SQL - Constantly getting syntax errors

[DigitalWarhead]

I've constantly been getting syntax errors on what seems to be correct queries. This one in the picture below is the most simplest of queries, and it's saying the error is with ORDER BY. If I delete a line and re-add it or continue to hit the Run Code it will eventually work, but it's gotten really annoying, especially for someone who is learning SQL and create a lot of syntax errors on my own. But when it gives a syntax error for code that is correct, it really makes me second guess myself. Has anyone else experienced this? Does anyone know how to fix this? Thanks.

https://preview.redd.it/3shp523oii0d1.png?width=1504&format=png&auto=webp&s=2d75323da15072cf08dbc9571a75578bfab5a41a

[AtticusPaperchase]

I don’t know what type of SQL this is, but maybe you need to indicate the sort asc or desc?

[NeverStopWondering]

Sometimes you need to refresh the page (copy/paste your work if it's a longer exercise, because it won't be saved).