Sql построить запрос

Если в мускуле нет каких-то функций транспонирования данных, то через большой копипейст:

SELECT YEAR(ORDER_DATE), JANSALES.AMT, FEBSALES.AMT, ..
FROM ORDER_HEADER
LEFT OUTER JOIN
(SELECT YEAR(ORDER_DATE) YR, SUM(ORDER_SUM) AMT
FROM ORDER_HEADER
WHERE MONTH(ORDER_DATE)=1
GROUP BY YEAR(ORDER_DATE)
) JANSALES
ON ORDER_HEADER.YEAR(ORDER_DATE) = JANSALES.YR
LEFT OUTER JOIN
(SELECT YEAR(ORDER_DATE) YR, SUM(ORDER_SUM) AMT
FROM ORDER_HEADER
WHERE MONTH(ORDER_DATE)=2
GROUP BY YEAR(ORDER_DATE)
) FEBSALES
ON ORDER_HEADER.YEAR(ORDER_DATE) = FEBSALES.YR
...