Is there any order of precedence in SQL?

I have a table as follows:
I just want the previous entry for every row from the column ‘marks’.

Does this PostgreSQL query makes sense?

I have a table as follows:
I just want the previous entry for every row from the column ‘marks’.