Using Date Functions

Sheila needs a report that displays the ages of the employee's dependents. She also wants to see how many years an employee has been with the company. Each employee is rewarded with a gift when longevity with the company reaches 10 years.

She needs to use the SYSDATE and MONTHS_BETWEEN functions to determine this information.

Show Me and Try It: Use SQL Workshop to build Sheila's reports