EF 6.x, LINQ-to-SQL and raw SQL clauses

var rows = from a in query
  group a by new {
    h = a.c.BookingRefex,
    b = a.c.ClientRefex,
    c = a.b.PickupCity,
    d = a.b.PickupPostalCode
  } into g
  select new { 
    BookingRefex = g.Key.h, 
    ClientRefex = g.Key.b, 
    SumQuantity = g.Sum(p => p.bg.Quantity),
    Value = g.First().c.Value
  }; 

var q = (from up in UserReports
    where up.UserType == "Internal"     
    && companies.Contains(up.CompanyId) && roleIDs.Contains(up.RoleId)
                         select new 
                         {
                             UserId = up.UserId,
                             FirstName = up.FirstName,
                             LastName = up.LastName, ...});

var q = (from up in UserReports
                         join c in companies on up.CompanyID equals c.Id
                         join r in rolesIDs on up.RoleId equals r.Id
                         where up.UserType == "Internal"
                         select new 
                         {
                             UserId = up.UserId,..});

var ud = db.Updates
              .Where(c => !c.Sold)
              .GroupBy(c => c.Vehicle, x => x, (x,gr) => new { key = x,
                  list = gr.ToList().OrderByDescending(z => z.TimeStamp).First() })
               .Where(x=> validStatuses.Contains(x.list.Status))
              .Select(x => x.list).ToList();

var output2 = thisCurrency.SelectMany(lc => otherCurrency.Select(oc => oc * lc));