oracle_00936,sql – ORA-00936：缺少表达式oracle

我有这个问题

SELECT DAL_ROWNOTABLE.DAL_ID FROM

(

SELECT ticket.id AS "DAL_ID",ROWNUMBER ( Order By ticket.id ) AS "DAL_ROWNUMBER"

FROM ticket_table ticket

WHERE ( ticket.type = N'I' )

AND

(

ticket.tenant IS NULL OR ticket.tenant IN

(

SELECT * FROM

(

SELECT tenant_group_member.tenant_id

FROM tenant_group_member

WHERE tenant_group_member.tenant_group = HEXTORAW('30B0716FEB5F4E4BB82A7B7AA3A1A42C')

ORDER BY ticket.id

)

)

)

) DAL_ROWNOTABLE

WHERE DAL_ROWNOTABLE.DAL_ROWNUMBER BETWEEN 1 AND 21

允许查询抛出ORA-00936缺少表达式的问题是什么？任何人？任何帮助将不胜感激…错误抛出列：80是在第一个订单的开头：