title: SQL Find Max Value and Number of Rows Whic Are Equal to That Value
body: <p>Given a table, I am trying to find Max Months * Hackos and number of ID's with the max Months * Hackos value.</p>
  <p>I tried the below code but it seems we cant use Max clause in the inner select.</p>
  <pre><code>SELECT MAX(MONTHS * HACKOS) AS MAXIMUM_HACKOS,
  (SELECT COUNT(ID) FROM HACKER WHERE MONTHS*HACKOS = MAX(MONTHS*HACKOS)) AS NUMBER_OF_HACKERS
  FROM HACKER ;
  </code></pre>
  <p>Correct expected output is 144 and 2 but my code is wrong.</p>
  <p><a href="https://i.stack.imgur.com/HmrfO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HmrfO.png" alt="Sample Input" /></a></p>