use Wintertalentiade

select a.AthletId, a.AthletLastName, a.AthletFirstName, a.AthletGender, year(a.AthletDateOfBirth) as Jahrgang, 
       a.AthletClub, [2],  [3],  [4],  [5],  [7],  [8],  [9],  [11],  [13],  [14],
	         round(  [2] + [3] + [4] + [5] + [7] + [8] + [9] + [11] + [13] + [14], 2) as Gesamtpunkte
from V_Einzelergebnisse r
join T_Athlets a
on r.AthletId = a.AthletId
order by a.AthletLastName, a.AthletFirstName


