Are you looking for the record with lowest cut difference everytime for each swimmer? I am guessing that will have the highest motivational_description according to your data, is that a correct statement?
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.