Linq subquery same table using lambda
<p>I've been trying for a while to use Linq and lambda expressions to translate a query that already exists in SQL, but there is something I'm missing...</p>

<p>This is the SQL query:</p>

<pre><code>select o.ord_no from orders o  where 1 &lt;= 
(select count(*) from orders where orders.purch_amt &lt; o.purch_amt 
and orders.ord_date = '2012-02-14')
</code></pre>

<p>How could I do the same query but using Linq and lambda expressions???</p>