MAMP - this is incompatible with sql_mode=only_full_group_by

Remove the option ONLY_FULL_GROUP_BY option in your MySQL configuration.

Fetch current sql_mode options:

show variables like 'sql_mode'\G
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

Remove ONLY_FULL_GROUP_BY

File -> Edit Template -> MySQL (my.cnf)

Add or modify this line below [mysqld]:

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION