SQL

laravel where in subquery

DB::table('users')
    ->whereIn('id', function($query)
    {
        $query->select(DB::raw(1))
              ->from('orders')
              ->whereRaw('orders.user_id = users.id');
    })
    ->get();

This will produce:

select * from users where id in (
    select 1 from orders where orders.user_id = users.id
)

laravel subquery in from clause

DB::table(DB::raw("({$query->toSql()}) as alias") )

subquery in laravel

1AVG(SUM(amount))