Yes! when I search about this issue I get this..
My SQL is version 5.7.18
Finally, note that ONLY_FULL_GROUP_BY is trying to protect you from queries that use the MySQL group by extensions in a way that isn't consistent with that feature's purpose. Starting in 5.7.x, a query that is rejected by ONLY_FULL_GROUP_BY may in fact be producing non-deterministic results or may be taking advantage of side effects or results that are correct by accident or coincidence -- rather than by design -- and such behavior could disappear in a future release (for example, due to changes in the query optimizer) and thus shouldn't be relied on.
The best solution is to make the queries theoretically correct.