GroupBy Table Widget

Embaixador::query()
  ->select('bairro', DB::raw('COUNT(*) as total'))
  ->groupBy('bairro')
  ->orderByDesc('total')
  ->limit(5)

Embaixador::query()
  ->select('bairro', DB::raw('COUNT(*) as total'))
  ->groupBy('bairro')
  ->orderByDesc('total')
  ->limit(5)

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'f3x_charbel.embaixadores.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select `bairro`, COUNT(*) as total from `embaixadores` group by `bairro` order by `total` desc, `embaixadores`.`id` asc limit 11 offset 0

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'f3x_charbel.embaixadores.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select `bairro`, COUNT(*) as total from `embaixadores` group by `bairro` order by `total` desc, `embaixadores`.`id` asc limit 11 offset 0