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 39.173622251142 AND 39.607323748858 AND Longitude BETWEEN -78.168864171858 AND -77.607673828142 GROUP BY 1;