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.

Free Webhosting No Ads

If you wish to have a professional shared hosting quality in a free hosting package, come and host with 000webhost and experience the best service you can get absolutely free. 



Founded in December 2006, 000webhost has a trusted free hosting members base of over 60,000 members and still counting! Offering professional quality hosting, support, uptime and reliability, we have a great community of webmasters, you'd love to be a part of! 

Register now and get it all free: 
*** 1500 MB of disk space 
*** 100 GB of data transfer
*** PHP and MySQL support with no restrictions
*** cPanel control panel
*** Website Builder
*** Absolutely no advertising! 

Join us now: http://www.000webhost.com/645312.html