What I'm trying to do is set a players division according to their age.
So if age is 8, update division to junior, if age is 9, update division
to medium, if age is 10, update division to pee wee, and etc.
I'm trying to accomplish this in a single query, and be able to run
this query and verify that players are in the right division.
Is it possible to update multiple records in a table with a single
query while having criteria?