title: Convert SQL to lambda in C#
body: <p>How can I re-write the following query from SQL to lambda in C#? Is it recommended to write in lambda?</p>
  
  <pre><code>SELECT * 
  FROM Claims 
  WHERE id IN (SELECT claimId 
               FROM MissingItems 
               GROUP BY claimId);
  </code></pre>