Query error:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thrift_db.zips.Latitude' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by-SELECT DISTINCT(stores.storeID),zips.Latitude,zips.Longitude FROM store AS stores INNER JOIN zipcode AS zips ON stores.storeZip = zips.Zipcode WHERE Latitude BETWEEN 40.490590251142 AND 40.924291748858 AND Longitude BETWEEN -80.393286563055 AND -79.821147436945 GROUP BY 1;