enter image description here
want to find the total two or more Total columns
Use GROUP BY and then SUM(condition) to obtain your counts:
GROUP BY
SUM(condition)
SELECT id AS ID, SUM(total = 'total' ) AS Total, FROM table GROUP BY ID
Something like this should work.