title: How to find employees hired less than ten years ago?
body: <p>I want to write a query to display the employee number, last name, hire date, and number of months employed for all employees who have worked for less than 10 years.</p>
  
  <p>This is what I have but something is wrong with the WHERE function:</p>
  
  <pre><code>SELECT employee_id, last_name, hire_date, MONTHS_BETWEEN(SYSDATE, hire_date) "number of months employed" 
  FROM employees
  WHERE MONTHS_BETWEEN(SYSDATE, hire_date) &lt;= 120;
  </code></pre>
  
  <p>PS: when I run it without the WHERE function, for the "number of months employed" I get <code>292.530207959976105137395459976105137395</code></p>
  
  <p>please help! :( </p>