We have a need to be able to do the following:
Have a set of judges (ranging from 5-7).
Each judge will be judging a category that contestants are competing in.
Each judge will give a contestant a score ranging from 1-12.
The tabulation of the scores is the following:
- Omit a high score, if there are multiple scores that are all the highest score, only omit one of them.
- Omit a low score, if there are multiple scores that are all the lowest score, only omit one of them.
- Add the remaining scores together.
Each contestants scores would be added to the database, so this would be to us, simple query manipulation, but it might be on the client app side as well.
Any guidance would greatly be appreciated.