如何计算12轮的前7名成绩

Question

earlier I asked how to get the best 3 results (which OTARIKI and Raging Bull answered)

for a static system that works great. ok my question.

how can I get the top 7 rounds out of 12 rounds (code below is static best 3 rounds out of 4)

SELECT RacerID ,  round1 + round2 + round3 + round4 - LEAST(round1, round2, round3, round4) AS Top3Rounds

FROM tablename

any ideas? many thanks again :)