Laravel order by relationship aggregates example

laravel-order-by-relationship-aggregates-column.php

<?php
$popularSerials = Serial::addSelect([
        'total_views' => Video::selectRaw('sum(views) as total_views')
            ->whereColumn('serial_id', 'serials.id')
            ->groupBy('serial_id')
    ])
    ->orderBy('total_views')
    ->get();