title: How to return multiple columns when using group by in SQL
body: <p>I want the names of the employees along with their salary and department who have maximum salary less than 50,000. ihave the following</p>
  
  <pre><code>SELECT department, MAX(salary) as Highest salary
  FROM employees
  GROUP BY department
  HAVING MAX(salary) &lt; 50000
  </code></pre>
  
  <p>How do I get the name of the employee to be returned?</p>