_______________

[Student123]

Trying to Run a few tables through the same query

[andy49]

something more like............. (I'm no expert!)

SELECT top 1 Student.Name, SUM(Test.Score) 

 from
 (SELECT TOP 21 Student.Name
        FROM Student INNER JOIN Test ON Student.StudentNumber =      Test.StudentNumber
       GROUP BY Student.Name)

 ORDER BY SUM(Manifest.Ticketprice) DESC

The theory is get the top 21 values you need as a subquery in brackets
then select the top 1 of those when they are ordered in the reverse order