one mistake i made in the inital post was that i said i ordered my trial test by minor, this is wrong i ordered it by student id as you can see from my SQL. Which is the way i'll sort my report.