求大神看一下sql server2012一个查询

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