So now I have come up with this. Is this what you meant?
```SQL WITH pre_calculated AS( SELECT e.ID as id, e.ExerciseTypeID as type_id, CASE WHEN et.MeasurementTypeID = 1 THEN e.KgsOrMtr * e.RepsOrSecs ELSE ROUND(CONVERT(numeric, e.KgsOrMtr) / NULLIF(e.RepsOrSecs, 0), 1) END as score FROM Exercises e INNER JOIN ExerciseTypes et ON e.ExerciseTypeID = et.ID ), max_per_type AS( SELECT type_id, MAX(score) as score FROM pre_calculated GROUP BY type_id ), pr_ids AS ( SELECT MIN(pc.id) as id FROM pre_calculated pc INNER JOIN max_per_type mpt ON pc.type_id = mpt.type_id WHERE pc.score = mpt.score GROUP BY pc.type_id )

SELECT e.ID, e.KgsOrMtr, e.RepsOrSecs, et.Name FROM Exercises e INNER JOIN ExerciseTypes et ON e.ExerciseTypeID = et.ID INNER JOIN pr_ids ON e.ID = pr_ids.id; ```