title: SQL: Finding all employees hired on a specific day of the week
body: <p>I have trouble finding all employees, that are hired on a day of the week(Monday,Tuesday etc.) that has the highest hiring rate.</p>
  
  <p>For exmaple: if Monday is the day that has the highest hiring count, I want to display all employees that are hired on that day of the week.</p>
  
  <p>I found which days has the highest hiring count:</p>
  
  <pre><code>SELECT COUNT(*), TO_CHAR(HIRE_DATE,'DAY') DAY
  FROM EMPLOYEES
  GROUP BY TO_CHAR(HIRE_DATE,'DAY')
  HAVING COUNT (*)=(SELECT MAX(COUNT(*))FROM EMPLOYEES GROUP BY TO_CHAR(HIRE_DATE,'DAY'));
  </code></pre>
  
  <p>But I can't display all employees hired on that days. Thank you in advance for your time.</p>