title: SQLDeveloper: lowest paid employee for a specified manager. Sample code given
body: <p>I am trying to write a query to display manager no. and the lowestwages employee for manager. we discard wages less than 1k
  So I tried writing a code for it but its giving me an error. I think I have to edit the FROM condition in the second line:</p>
  
  <pre><code>SELECT empno, sal
  FROM emp a, emp b
  WHERE   empno IN (SELECT boss.empno
                    FROM emp a, emp boss
                    WHERE a.super = boss.empno)
  AND MIN(sal) &gt;1000;
  </code></pre>