/* If you see the result set, it contains 1 row less than sample data. The result set contains only those rows where the difference between most recent and second recent date is greater than 365 OR difference between second recent date and oldest date is greater than 365 */

They have random dates. For each row, I need to find the recent, second recent and oldest date and once I get that, I need to compare -

List out the assets information where Difference between recent date and second recent date is greater than 1 year.

List out the assets information where Difference between second recent date and oldest date is greater than 1 year.

Point 2 should NOT include the assets which are already included in point 1