Custom Aggregate Table

class CustomPage extends Page implements HasTable
{
    use InteractWithTable;
    ...
    
    protected function getTableQuery(): Builder
    {
        return CustomsData::query()
            ->select('importer')
            ->selectRaw('COUNT(product) as total_import')
            ->selectRaw('SUM(qty) as total_qty')
            ->selectRaw('SUM(value) as total_value')
            ->groupBy('importer');
    }

    public function table....
    ...

    public function getTableRecordKey(Model|array $record): string
    {
        return uniqid();
    }
}

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'customs_data.customs_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (Connection: mysql_customs_data, SQL: select `importer`, COUNT(product) as total_import, SUM(qty) as total_qty, SUM(value) as total_value from `customs_data` where (date(`import_date`) >= 2025-07-08 and date(`import_date`) <= 2025-10-08) group by `importer` order by `total_value` desc, `customs_data`.`id` asc limit 10 offset 0)