It's up to you how you select them, but keep in mind "%Guard%" matches "Guard Bob" and "Marshmallow Guardian", and "%pet%" matches anything with 'pet' anywhere in the name, like the mythical carpet monster, etc. You would most likely want to run all of the where queries alone to make sure you're not picking up anything you want included in the average and adjust to not exclude them. In case you didn't know, you can use something like "Guard%" to only select names where they begin with "Guard". To exclude pets I would probably check against the npcID in the pets table rather than trying to do it by name.
|