How do I compare rows in a table? (meta data)

[essalj666]

Hi.I have a job doing a daily extract of metadata on all apps in production.

In order to  assess data quality of most recent load, I want to compare to earlier days.

But I cannot get i t to work.

I have a table looking like this

What I want is something like this: 

- one line pr app

- masures from the most recent date in the three last weeks  (appsize0-2, columnCOunt0-2 and table_Count 0-2)

- and the max load date.

How can I do this?