For the purpose of my report it is acceptable to use the last modifiedon date and this will not change once a Case is resolved

Thank you for this - Now I see it written down I realise the mistake I have made -

Any ideas how I can get all 4 into one query? ...