How can you make a selection based on a changing value

How can I make a SQL fetch using a template from the picture? The result should look like this

1  6.61  63000
2  6.51  121
3  6.52  333
4  6.51  333

According to this pattern