SQL求助

MENG1

SELECT
LECTURER_EMPNO_NEW,
sum(TOTALTIME) AS TOTALTIME,
sum(CREDIT) AS CREDIT
FROM
(
SELECT
  LECTURER_EMPNO_NEW, sum(NVL(duration, 0)+ NVL(out_duration, 0)) AS totaltime, sum(NVL(duration, 0)+ NVL(out_duration, 0))* 2 AS credit
FROM
  train_apply LATERAL VIEW explode(split(trim(LECTURER_EMPNO), ';')) num AS LECTURER_EMPNO_NEW
WHERE
  flow_id IN ('FlowEndNode    ')
  AND classtype = 1
GROUP BY
  LECTURER_EMPNO_NEW )
GROUP BY
LECTURER_EMPNO_NEW

报错：SQL 错误 [933] [42000]: ORA-00933: SQL 命令未正确结束

jishuang

sql到数据库执行，根据提示具体错误的地方去修改