使用oracle数据库建表语句,怎么使用sql查询oracle建表语句

SELECT CREATETION AS "年份"

,SUM(DATE_ROW01) AS "01月"

,SUM(DATE_ROW02) AS "02月"

,SUM(DATE_ROW03) AS "03月"

,SUM(DATE_ROW04) AS "04月"

,SUM(DATE_ROW05) AS "05月"

,SUM(DATE_ROW06) AS "06月"

,SUM(DATE_ROW07) AS "07月"

,SUM(DATE_ROW08) AS "08月"

,SUM(DATE_ROW09) AS "09月"

,SUM(DATE_ROW10) AS "10月"

,SUM(DATE_ROW11) AS "11月"

,SUM(DATE_ROW12) AS "12月"

FROM

(

SELECT CREATETION

,NVL(CASE

WHEN MONTH = '01' THEN SUM(COMMISSION) END,0) AS DATE_ROW01

,NVL(CASE

WHEN MONTH = '02' THEN SUM(COMMISSION) END,0) AS DATE_ROW02

,NVL(CASE

WHEN MONTH = '03' THEN SUM(COMMISSION) END,0) AS DATE_ROW03

,NVL(CASE

WHEN MONTH = '04' THEN