我正在输入以下代码，它返回给我“ORA-00923：FROM 关键字未在预期的位置找到”。怎么了？
SELECT
max(alias.id) AS "id",
(SELECT alias.name FROM EXAM WHERE alias.id = alias.id ) AS "REF",
alias.name
FROM EXAM alias
GROUP BY alias.name
ORDER BY alias.name ASC;