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.629527251142 AND 40.063228748858 AND Longitude BETWEEN -96.927743559109 AND -96.362844440891 GROUP BY 1;