MySQL Server SQL modes

My colleague recently encountered a Drupal error as follow: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggrega...