select sum(col1) from tbl group by 1