Redmine

Hi, people, I'm trying to get the following information from my project:
- For each status in the history of an issue, how much time was spent?
A report would look like this:

Issue Status from Status To Time Spent
1 State A State B 1day 2hours
...

I was looking forward something like this in plugins directory and I found nothing.
I know the basic query to get this is:
select journalized_id, journalized_type, created_on, old_value, value from journals jo, journal_details jod where jo.id=jod.journal_id and prop_key='status_id';
But I don't know how to create a plugin
TIA
Gabriel