SELECT guid, SUM(`type`) as `HKill`, ( count(*) - SUM(`type`) )  as `UKill` from character_kill where guid = 1