求大神看一下这个表怎么写sql能查出上面的结果？

求解

SELECT NODENO,DELIVERYNO,OILCAN,
MAX(CASE WHEN STATUS=1 THEN 1 END) STATUS1,
MAX(CASE WHEN STATUS=1 THEN opeTime END) opeTime1,
MAX(CASE WHEN STATUS=2 THEN 2 END) STATUS2,
MAX(CASE WHEN STATUS=2 THEN opeTime END) opeTime2,
MAX(CASE WHEN STATUS=3 THEN 3 END) STATUS1,
MAX(CASE WHEN STATUS=3 THEN opeTime END) opeTime3
FROM TABLE
GROUP BY NODENO,DELIVERYNO,OILCAN