CODE EXAMPLE FOR SQL

date functions

SELECT
    FirstName,
    LastName,
    HireDate,
    strftime('y%-m%-d%', HireDate) - strftime('y%-m%-d%','now') AS Tenure
FROM
    EMPLOYEES
ORDER BY
    Tenure