带有子查询、计数、最大值、总和、扩展为on的左连接的Linq查询

var query = from customer in customers
            where customer.Orders.Count() > 0
            select new
            {
                customer.Name,
                TotalOrders = customer.Orders.Count(),
                MaxOrderAmount = customer.Orders.Max(order => order.Amount),
                TotalOrderAmount = customer.Orders.Sum(order => order.Amount),
                OrdersWithProducts = from order in customer.Orders
                                     join product in products on order.ProductId equals product.Id into orderProducts
                                     from orderProduct in orderProducts.DefaultIfEmpty()
                                     select new
                                     {
                                         order.Id,
                                         orderProduct?.Name
                                     }
            };