title: To Group By Hire Date in SQL Server?
body: <p>Assume the following table</p>
  
  <p><strong>Employee</strong></p>
  
  <pre><code>EmployeeID           INT
  FirstName            VARCHAR(50)
  LastName             VARCHAR(50)
  SupervisorEmployeeID INT
  Salary               MONEY
  HireDate             DATETIME
  </code></pre>
  
  <ol>
  <li><p>How to show the number of employees hired per year for the last 5 years also include the average salary for employees hired in those years.</p></li>
  <li><p>How to show the number of employees hired per year for the last 5 years also include the average salary for employees hired in those years.</p></li>
  </ol>