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 29.518225251142 AND 29.951926748858 AND Longitude BETWEEN -99.289808425155 AND -98.790331574845 GROUP BY 1;