Complicated problem

Here is my issue  !!!
I have a table called student with fields
name   level     choice1      choice2        choice3 ....... til choice10
and another table called classes with fields and max quantity

class1     class2 ....till 10
max10     max7

I want to reorder and insert all of the data based on the level from level1 ......til 100
I mean student-level one has the chance to get his choice ignoring the limit and when the classroom status change to max the next student will get the second choice automatically

I hope I cleared my idea