How to fetch the status history for an incident.

Content

Hello Everyone:

            I need to develop a ROQL query to retrieve the status history for each incident. Attached is the document containing the screenshot of the sample data, which I need to retrieve.

           Can anyone please guide me with the ROQL query to get this kind of historical data once, the incident is closed?

Thank you,

Farhad P. 

Version

Service Cloud