P99 class distribution

[Tallenn]

No idea about the timelaston, so I just made those 56 queries (4 per class). I'm not sure about the print statement either. I've never used it, just found it on Internet. If messed up, let me know, I'll fix it.

PRINT "Warriors Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '1'

PRINT "Warriors Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '1'

PRINT "Warriors Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '1'

PRINT "Warriors Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '1'

PRINT "Clerics Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '2'

PRINT "Clerics Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '2'

PRINT "Clerics Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '2'

PRINT "Clerics Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '2'

PRINT "Paladins Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '3'

PRINT "Paladins Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '3'

PRINT "Paladins Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '3'

PRINT "Paladins Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '3'

PRINT "Rangers Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '4'

PRINT "Rangers Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '4'

PRINT "Rangers Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '4'

PRINT "Rangers Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '4'

PRINT "Shadow Knights Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '5'

PRINT "Shadow Knights Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '5'

PRINT "Shadow Knights Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '5'

PRINT "Shadow Knights Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '5'

PRINT "Druids Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '6'

PRINT "Druids Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '6'

PRINT "Druids Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '6'

PRINT "Druids Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '6'

PRINT "Monks Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '7'

PRINT "Monks Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '7'

PRINT "Monks Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '7'

PRINT "Monks Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '7'

PRINT "Bards Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '8'

PRINT "Bards Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '8'

PRINT "Bards Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '8'

PRINT "Bards Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '8'

PRINT "Rogues Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '9'

PRINT "Rogues Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '9'

PRINT "Rogues Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '9'

PRINT "Rogues Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '9'

PRINT "Shaman Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '10'

PRINT "Shaman Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '10'

PRINT "Shaman Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '10'

PRINT "Shaman Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '10'

PRINT "Necromancers Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '11'

PRINT "Necromancers Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '11'

PRINT "Necromancers Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '11'

PRINT "Necromancers Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '11'

PRINT "Wizards Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '12'

PRINT "Wizards Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '12'

PRINT "Wizards Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '12'

PRINT "Wizards Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '12'

PRINT "Magicians Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '13'

PRINT "Magicians Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '13'

PRINT "Magicians Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '13'

PRINT "Magicians Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '13'

PRINT "Enchanters Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '14'

PRINT "Enchanters Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '14'

PRINT "Enchanters Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '14'

PRINT "Enchanters Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '14'