my question is finding out how to label the top 3 entries based on column "avg_score, in a table, while still showing the rest of the entries, but without a label. So say I have a table like this:
Entry avg_score
entry_1 | 4.3
entry_2 | 9.4
entry_3 | 4.6
entry_4 | 7.1
entry_5 | 2.1
entry_6 | 1.9
I want to be able to find the top 3 based on the column 'avg_score' and display it like:
"1st place: entry_2
2nd place: entry_4
3rd place: entry_3
entry_1
entry_5
entry_6"
Any help would be appreciated!