sub query to get data from mysql with php

I want to get data from mysql data by filtering different columns and want to compare each other. 
I have following data in database.

I want to get General Shift of year 2010, 2011, 2012, 2013 and 2014 and later compare them means sum of all. and same for Shifts and common. and also want to get by designation. I am using following php script get year wise data but can't compare it. 

please help me to solve this problem.