maybe of some use

with cte_names as

(

SELECT StudentID, MAX(StudentName) AS StudentName

FROM lcdscores

GROUP BY StudentID

)

SELECT lcdscores.StudentID

, cte_names.StudentName

, CAST ( AVG ( lcdscores.focus1 ) AS decimal ( 9 , 2 )) AS focus1

, CAST ( AVG ( lcdscores.cont1 ) AS decimal ( 9 , 2 )) AS controlling1

FROM

lcdscores INNER JOIN cte_names ON lcdscores.StudentID = cte_names.StudentID

GROUP BY lcdscores.StudentID

, cte_names.StudentName;