分组依据中的Mysql时间差异

Question

我有一张times桌子。我想创建一个视图，这将给我主键和所有传感器的时间差异。

传感器是休闲式的：

 0.   start
 1-3. on track timers
 4.   end

示例将显示最好的：

Times table:
----------------------------------------------------------
| TimeID | RaceID | RacerID | Round | Sensor |    Time    |
-----------------------------------------------------------
|   1    |    1   |    1    |   1   |    0   |   100540   |
-----------------------------------------------------------
|   2    |    1   |    2    |   1   |    0   |   154297   |
-----------------------------------------------------------
|   3    |    1   |    1    |   1   |    1   |   170134   |
-----------------------------------------------------------
|   4    |    1   |    2    |   1   |    1   |   185915   |
-----------------------------------------------------------
|   5    |    1   |    1    |   1   |    2   |   200137   |
-----------------------------------------------------------
|   6    |    1   |    2    |   1   |    2   |   235103   |
-----------------------------------------------------------
|   7    |    1   |    1    |   1   |    4   |   380123   |
-----------------------------------------------------------
|   8    |    1   |    2    |   1   |    4   |   421127   |
-----------------------------------------------------------

Desired view
-----------------------------------------------------------------------
| TimeID | RaceID | RacerID | Round | Time1 | Time2 | Time3 |   Total |
-----------------------------------------------------------------------
|   1    |    1   |    1    |   1   | 69594 | 99597 |  null |  279583 |
-----------------------------------------------------------------------
|   1    |    1   |    2    |   1   | 31618 | 80806 |  null |  266830 |
-----------------------------------------------------------------------

http://sqlfiddle.com/#!9/10c5f/1