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 30.950329251142 AND 31.384030748858 AND Longitude BETWEEN -98.026135552421 AND -97.519264447579 GROUP BY 1;