MySQL Script for Statistic

select
    ac.name,
    ac.kills,
    ac.deaths,
    count(ki.killer_uid) as 'count of kill',
    max(ki.distance) as 'max of dist',
    (select kil.weapon from kills kil where kil.distance = max(ki.distance) limit 1) as 'weapon'
from
    account ac
    join kills ki on (ac.uid = ki.killer_uid)
where
    NOT (ki.killer_uid = 'Admin UUID' )
group by
    ki.killer_uid