odps sql 子查询再联表查询时，报错！

SELECT a.*

, round(a.count / b.count, 2) AS count_percent
, round(a.amount / b.amount, 2) AS amount_percent

FROM (

SELECT COUNT(id) AS count
    , round(SUM(goods_money) / 100, 0) AS amount
    , create_date
FROM ingping_recently_three_month_site_order
WHERE order_type = 3
GROUP BY create_date

) a
LEFT OUTER JOIN ingping_recently_three_month_order_statistics_20161107 b
ON a.create_date = b.create_date;

上面odps sql 子查询再联表查询时，报错！经仔细查找还是没有发现问题出在哪里！
错误代码：
FAILED: ODPS-0130071:Semantic analysis exception - Invalid column reference : line 13:21 'create_date'

请给出解决方法！！

已经解决了，之前创建的sql语句是没有包含create_date 这个字段， 新sql包含create_date 字段，需要手动删除旧表再运行新sql语句！