Sqlite - Get Cell Column Order With Cell Content

i have been making my internship on a project, which saving runners target access time (TAT) and i am trying to get some valuable results from these times.

Example How much time have runners spend between targets? (Target Time - TT)

What is the rank of runner at TAT?

Also need rank of runner at target time but now TAT is important.

I prepared some images for explain myself;

Here what i have. I saved this query result as view now i have been working on this view for a while (View name is "RunnerTimes").

<table width="904" height="164" border="1">
  <tr>
    <td width="48" height="38">Name</td>
    <td width="159">Target 1 AccessTime</td>
    <td width="159">Target 2 AccessTime</td>
    <td width="169">Target 3 AccessTime</td>
    <td width="172">Target 4 AccessTime</td>
    <td width="157">Target 5 AccessTime</td>
  </tr>
  <tr>
    <td height="37">John</td>
    <td>13:06:00</td>
    <td>13:25:00</td>
    <td>13:32:00</td>
    <td>13:42:00</td>
    <td>13:53:00</td>
  </tr>
  <tr>
    <td height="38">Alice </td>
    <td>13:07:00</td>
    <td>13:22:00</td>
    <td>13:34:00</td>
    <td>13:44:00</td>
    <td>13:56:00</td>
  </tr>
  <tr>
    <td height="39">Mark</td>
    <td>13:05:00</td>
    <td>13:27:00</td>
    <td>13:34:00</td>
    <td>13:41:00</td>
    <td>13:54:00</td>
  </tr>
</table>

But my supervisor needs something more complicated table.

<table width="904" height="342" border="1">
  <tr>
    <td width="48">Name</td>
    <td width="159">Target 1 AccessTime</td>
    <td width="159">Target 2 AccessTime</td>
    <td width="169">Target 3 AccessTime</td>
    <td width="172">Target 4 AccessTime</td>
    <td width="157">Target 5 AccessTime</td>
  </tr>
  <tr bgcolor="#FFCC66">
    <td>John</td>
    <td>13:06:00 (2)</td>
    <td>13:25:00 (2)</td>
    <td>13:32:00 (1)</td>
    <td>13:42:00 (2)</td>
    <td>13:53:00 (1)</td>
  </tr>
  <tr>
    <td height="51">&nbsp;</td>
    <td>&nbsp;</td>
    <td> <p>time = 00:19:00 <br>
      time = target2 - target1</p></td>
    <td>00:07:00</td>
    <td>00:06:00</td>
    <td>00:11:00</td>
  </tr>
  <tr bgcolor="#FFCC66">
    <td>Alice </td>
    <td>13:07:00 (3)</td>
    <td>13:22:00 (1)</td>
    <td>13:34:00 (2)</td>
    <td>13:44:00 (3)</td>
    <td>13:56:00 (3)</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td> 00:15:00</td>
    <td>00:12:00</td>
    <td>00:10:00</td>
    <td>00:12:00</td>
  </tr>
   <tr bgcolor="#FFCC66">
    <td>Mark</td>
    <td>13:05:00 (1)</td>
    <td>13:27:00 (3)</td>
    <td>13:34:00 (3)</td>
    <td>13:41:00 (1)</td>
    <td>13:54:00 (2)</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td> 00:22:00</td>
    <td>00:07:00</td>
    <td>00:07:00</td>
    <td>00:13:00</td>
  </tr>
</table>

How do I achieve this ranks "(2)" or "(1)" like at this table.

I tried to do it by myself in C# but its ultraslow, calculating Target Times, querying runner ranks and after adding these to table is very slow.

Can some one help me? Sorry for bad english cheers :)