title: ORA-00934: Group function not allowed here || Selecting MIN(Salary) of highest paid dept
body: <p>O community, do you know how I could <strong>select the department_ID, and lowest salary of the department with the highest average salary?</strong> Or how to eliminate the'ORA-00934: group function not allowed here' issue? Would I need to use two subqueries?</p>
  
  <p>So far, this is what I've come up with, trying to get the department_ID of the highest paid department:</p>
  
  <pre><code>SELECT department_ID, MIN(salary
  FROM employees
  WHERE department_ID = (SELECT department_ID
      FROM employees WHERE salary = MAX(salary));
  </code></pre>
  
  <p>Thank you, your assistance is greatly appreciated.</p>