Given this code that builds on top of Entity Framework, what determines where the filtering runs (in the database vs in memory)?
IQueryable<Order> q = db.Orders;
var result = q.Where(o => o.Total > 100)
.AsEnumerable()
.Where(o => o.Notes.Contains("urgent"))
.ToList();