将行转换为列的sql查询。
sql查询，以从表1获得类似于表2的结果
表1

----------------------------------
   | id | quetion | options | answer
   ----------------------------------
   | 1  | que1    | op11    |  0
   | 1  | que1    | op12    |  0
   | 1  | que1    | op13    |  1
   | 1  | que1    | op14    |  0
   | 2  | que2    | op21    |  0
   | 2  | que2    | op22    |  0
   | 2  | que2    | op23    |  0
   | 2  | que2    | op24    |  1
   ---------------------------------

表2

----------------------------------------------------
   | id | quetion | o1   | o2   | o3   | o4   | answer
   ----------------------------------------------------
   | 1  | que1    | op11 | op12 | op13 | op14 |  3
   | 2  | que2    | op21 | op22 | op23 | op24 |  4
   ----------------------------------------------------