What I think you will have to do is have separate queries for each round. You would then need to process these to find out which people have not progressed to the next round.
Off the top of my head, I don't have a great solution, but I will look at this a little later when I have some time and see what I can come up with.
I assume you have two main tables:
Name Class ...
Name Round Attempt Score
C______1______ 1_______ 1
C______1______ 2_______ 1
C______1______ 3_______ 1
Can you post some DDL for the tables or do you care?