Pl/SQL: Get the last active day of a user in each year since he/she signed up : I have DATE logs for users when he/she was active.<br> I want to filter out his/hers last active day in each year, since he/she joined the service.

example:<br><b>
    logged dates:<br>
        12-1-2015<br>
        1-7-2015<br>
        21-12-2015<br>
        1-1-2016<br>
        2-2-2017<br>
        9-9-2017<br>
        12-10-2017<br>
        30-12-2017<br></b>

expected Output:<br><b>
        21-12-2015<br>
        1-1-2016<br>
        30-12-2017<br></b>
