title: Rows with Award due in 5 years only. Don't want to see Null
body: <p>Is there any more efficient way to see only rows where awards are due?</p>
  <pre><code>SELECT
      [JobTitle],
      DATEDIFF(YEAR,HireDate,Getdate()) AS Current_service_years,
      5 + DATEDIFF(YEAR,HireDate,Getdate()) AS Five_years_later,
      CASE
      WHEN 5 + DATEDIFF(YEAR,HireDate,Getdate()) = 20 THEN 'TRUE'
      END AS Award_due
  FROM [HumanResources].[Employee]
  </code></pre>