title: MySQL - select highest salary
body: <p>i need to select a person who lives in a city which name starts with "W" letter and has the highest salary.
  I tried this condition:</p>
  
  <pre><code>SELECT o.imię, o.nazwisko, e.pensja, mO.nazwa 
      FROM etaty e, osoby o, miasta mO
      WHERE(e.id_osoby = o.id_osoby) AND (mO.id_miasta = o.id_miasta) 
      AND mO.nazwa LIKE 'W%' 
      AND  e.pensja = (SELECT MAX(eW.pensja) AS mp FROM etaty eW)
  /* pensja = salary */
  </code></pre>
  
  <p>I have no errors but no results.
  When i try to drop out this salary condition everything work perfectly fine or when i try to drop out this name condition - also. But i can't mix this two conditions and make it work fine. What should i do?</p>