DividingSUMByADistinctCountandgettinganerror我在以下查询中收到ORA-00937(不是按功能分组的单组)。请问有什么想法吗？查询只是将SUM除以Count。12345SELECTSUM(DISTINCTCE.USD_NOTIONAL)/(SELECTCOUNT(DISTINCTMARKET_DATE)FROMDATA_EURO_YTDWHEREMARKET_DATE>=TO_DATE('2019-01-01','YYYY-MM-DD')) FROMCEWHERECE.tradedate>='01-JAN-2019'ANDCE.exchangeIN(S
