Exporting a sorted sum column with ExportAction

   TextColumn::make('rides_sum_distance')
                    ->label('Total distance')
                    ->sum('rides', 'distance')
                    ->default(0)
                    ->formatStateUsing(fn (string $state): string =>  number_format($state, 2, ',', '.') . ' km')
                    ->sortable()
                    ->badge()

   public static function getColumns(): array
    {
        return [
            ExportColumn::make('id')
                ->label('ID'),
            ExportColumn::make('name'),
            ExportColumn::make('email'),
            ExportColumn::make('created_at'),
            ExportColumn::make('rides_sum_distance')
                ->sum('rides', 'distance')
                ->default(0)
                ->formatStateUsing(fn (string $state): string => number_format($state, 2, ',', '.') . ' km '),
        ];
    }

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rides_sum_distance' in 'order clause' (Connection: mysql, SQL: select distinct * from `users` order by `rides_sum_distance` desc limit 100 offset 0)