Error

Error while accessing the database Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'SubQuery.EDU HRS' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by select count(*) from (SELECT YEAR(hrs_vol.vol_date) 'YEAR', SUM(hrs_vol.v_hrs) 'VOL HRS', SUM(hrs_vol.adults) 'ADULTS', SUM(hrs_vol.youth) 'YOUTH', SubQuery.`EDU HRS` FROM hrs_vol, (SELECT YEAR(hrs_edu.edu_date) 'YR', SUM(hrs_edu.e_hrs) 'EDU HRS' FROM hrs_edu WHERE YEAR(hrs_edu.edu_date) > 2005 GROUP BY YEAR(hrs_edu.edu_date)) SubQuery WHERE YEAR(hrs_vol.vol_date) > 2005 AND YEAR(hrs_vol.vol_date) = SubQuery.YR GROUP BY YEAR(hrs_vol.vol_date)) nm_sel_esp