title: Subquery in a Lambda Expression or LINQ
body: <p>How can you write this query using a lambda expression or LINQ:</p>
  
  <pre><code>SELECT    *
  FROM      vehicles 
  WHERE     (memo1 like '%CERTIFIED%' OR memo2 = 'CERTIFIED')
  AND       stockno IN (SELECT stockno FROM udealer2 where ACC='UCERT')
  ORDER BY  model, days DESC
  </code></pre>