[lerxst2112]

SELECT AVG(`hp`) FROM `npc_types` WHERE `level` = 45;

You may want to add to the WHERE so you don't select guards, pets, etc. You'd just need to figure out how to select them so you can exclude them.