Check out example codes for "this is incompatible with sql_mode=only_full_group_by". It will help you in understanding the concepts better.

Code Example 1

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Code Example 2

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Learn ReactJs, React Native from akashmittal.com