Check out example codes for "full sql mode". 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',''));

Learn ReactJs, React Native from akashmittal.com