$pend_count{$columns[2]} += $columns[4];
$run_count{$columns[2]} += $columns[5];

##</code><code>##

select name, sum(pend), sum(run)
from click group by name