query to write the details of a person whose earning in a day is greater than or equal to their earning in the previous day : Table: Info

[Table][1]


[Sample Output][2]


  [1]: https://i.stack.imgur.com/UEpyh.jpg
  [2]: https://i.stack.imgur.com/yQi6p.jpg


This is a college exercise. I have just started learning SQL and don't understand how can you select data from two different rows of a column and create different columns in the sample output. My attemp is completely useless so I'm not putting it here as I only know how to select separate columns. Thank you in advance