I'm not sure if I'm going to have to do in a couple queries or not, but assistance is appreciated.

STUDENTS
----------------
StudentID PK
FirstName
LastName

QUIZPAIRINGS  (Intersection)
---------------------
STUDENTID1 PK
STUDENTID2 PK
TESTID PK
bInRegularTest
bInAdvancedTest

SCORES
-------------
StudentID PK
TestID PK
Score


The object is to show the combined scores for the paired students who took the advanced test for test 101 sorted from highest to lowest combined score.

    Partner1, Partner 2, Partner 1 score, Partner 2 score, combined score
1)  John Doe | Mary Doe | 400 | 399 | 799
2)  Jenny Doe | Helen Doe | 300 | 340 | 740
3)  Martin Doe | Greg Doe | 200 | 220 | 420