新人，新人挑战赛代码出错求助。。。

跟着视频打的代码运行后提示错误，，，各位大神来看看吧，，，，
DROP TABLE IF EXISTS tianchi_mobile_recommendation_predict;
CREATE TABLE tianchi_mobile_recommendation_predict AS
SELECT C.USER_ID, C.ITEM_ID
FROM
(
    SELECT A.USER_ID,A. ITEM_ID
    FROM
    (
        SELECT USER_ID, ITEM_ID
        FROM TRAIN_USER
        WHERE TIME >= "2014-12-18 12" AND TIME < "2014-12-19 00" AND BEHAVIOR_TYPE==3
        GROUP BY USER_ID, ITEM_ID
    )A
    LEFT OUTER JOIN
    (
    SELECT USER_ID, ITEM_ID
    FROM TRAIN_USER
    WHERE TIME>= "2014-12-18 12" AND TIME< "2014-12-19 00" AND BEHAVIOR_TYPE==4
    GROUP BY USER_ID, ITEM_ID
    )B
    ON A.USER_ID == B.USER_ID AND A.ITEM_ID == B.ITEM_ID
    WHERE ISNULL (B.ITEM_ID)
)C
LEFT OUTER JOIN TRAIN_ITEM D
ON C.ITEM_ID == D.ITEM_ID
WHERE !ISNULL(D.ITEM_ID)
GROUP BY C.USER_ID,C.ITEM_ID;