MySQL uses group by reporting this is incompatible with Sql_mod

Here is all the data for the employee table.

Error using GROUP by group query This is incompatible with sql_mode=only_full_group_by

View Sql_model parameter discovery:
Only_full_group_by,strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_ User,no_engine_substitution

Only_full_group_by option is on, you can only select the option after group by when using group by, or use aggregate functions.
Query only the columns following group by:

Use aggregate functions:

But the above two methods are NOT recommended!!!
Recommended Workaround:
1. Temporary, restart MySQL will fail

SET @ @GLOBAL. sql_mode=strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_ Create_user,no_engine_substitution
2. Modify/ETC/MY.CNF
[Mysqld]
Add a row
Sql_mode=strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_ Engine_substitution
Restarting MySQL will take effect.

MySQL uses group by reporting this is incompatible with Sql_mod