Aggregated Table with Bulk Action

fn() => Opportunity::select('seller')
                    ->selectRaw("ROW_NUMBER() OVER (ORDER BY COUNT(CASE WHEN asset_class = 'Aircraft' THEN 1 END)) AS id")
                    ->selectRaw("COUNT(CASE WHEN asset_class = 'Aircraft' THEN 1 END) AS aircraft_count")
                    ->selectRaw("COUNT(CASE WHEN asset_class = 'Engine' THEN 1 END) AS engine_count")
                    ->selectRaw("COUNT(CASE WHEN asset_class = 'Ship' THEN 1 END) AS ship_count")
                    ->selectRaw("COUNT(CASE WHEN asset_class = '' THEN 1 END) AS other_count")
                    ->where('deal_stage', '!=', '00. Training')
                    ->groupBy('seller')
                    ->orderBy('aircraft_count', 'desc')