title: LINQ query with multiple aggregates
body: <p>How would I create the equivalent Linq To Objects query?</p>
  
  <pre><code>SELECT MIN(CASE WHEN p.type = "In" THEN p.PunchTime ELSE NULL END ) AS EarliestIn,
         MAX(CASE WHEN p.type = "Out" THEN p.PunchTime ELSE NULL END ) AS LatestOUt
  FROM Punches p
  </code></pre>