How could I remove repetition from this linq-to-entities query?

Question

This linq query works, and it does what I want it to do, but is there any other way I could improve the query so I'm not repeating a.AnswerRevisions.OrderByDescending(r => r.DateCreated).FirstOrDefault()?

IQueryable<Article> query = from a in _db.Articles
                            orderby a.DateCreated descending
                            where a.AnswerRevisions.Count > 0 &&
                            (a.AnswerRevisions.OrderByDescending(r => r.DateCreated).FirstOrDefault().UpVotes -
                             a.AnswerRevisions.OrderByDescending(r => r.DateCreated).FirstOrDefault().DownVotes < 0)
                            select a;

Answer 1

Use the let statement and also do the final orderby after the where clause, this will increase efficiency, as less entries will have to be sorted

IQueryable<Article> query = from a in _db.Articles 
    let  rev = a.AnswerRevisions.OrderByDescending(r => r.DateCreated).FirstOrDefault()
    where a.AnswerRevisions.Count > 0 && 
          (rev.UpVotes - rev.DownVotes < 0) 
    orderby a.DateCreated descending 
    select a;