Querry to fetch Test run report (failed, no run, passed ecc) with the Test name (Subject) and the test run date

Dears,

I kindly ask your support for a query that shows the Test run report (failed, no run, passed ecc) with the Test name (Subject) and the test run date.

Thank you and best regards

Albi