Oracle sql 缺少表达式

Question

我有一个 Oracle SQL 查询并运行该查询，它给出了 ORA-00936: 缺少表达式。当我将鼠标悬停在 Oracle Sql Developer 中的红色上时，它显示“语法错误。部分识别的规则、铁路图。我认为我的 Group By 有问题。我认为 Group by 需要包含所有查询列，但我知道最后 3 个是最小值/最大值/平均值，所以我认为将它们分别添加到组中没有意义将它们添加到组中的正确方法是什么？

 select        
    do.dcode,
    ds.SERIALNO,  
    ds.BASECOMPONENTCODE,
    TO_CHAR (strt.DLOCALECRTDT,'MON') as MON,--this looks like 13-OCT-15 05.19.03.000000000 PM
    Max (do.METRICVALUE)  as MaxCount,   
    min (do.METRICVALUE)  as MinCount,
    avg (do.METRICVALUE)  as AvgCount

          FROM
            TECH_DWH.D_DIM_OUTPUTCOUNT_TBL do
             join (
                     Select d1.dcode,d1.organizationid
                     from  K_D_VW d1
                     where
                    d1.isactive='Y'
         and d1.organizationid = 7500 -- company id
                    ) d on d.dcode=do.dcode
             left join
            TECH_DWH.D_COMPSTAT_SERIAL_NO_MAP_TBL csm on csm.DCOMPONENTSTATEID = do.DCOMPONENTSTATEID
             join TECH_D.D_DIM_SERIAL_NO_TBL  ds on ds.serialnoid = csm.serialnoid
             left join TECH_DWH.d_dim_medianumber_tbl dm on dm.DCOMPONENTSTATEID = csm.DCOMPONENTSTATEID
    left join TECH_DWH.D_DEVICE_COMPSTATE_STRT_TBL strt on strt.DCOMPONENTSTATEID = csm.DCOMPONENTSTATEID

           WHERE
           instr(upper(ds.basecomponentcode),'PRINT')>0  AND --- return only device components
            LENGTH(TRIM(TRANSLATE((do.METRICVALUE), ' +-.0123456789',' '))) is null -- test for only rows with numberic metrivalue's
     AND do.dcode like '0046'
    AND strt.COMPONENTSTATECODE like '%EP_DEVICE%'
            and strt.DLOCALECRTDT >= to_date ( '30-12-2021', 'DD-MM-YYYY' )
            and 
            Group by  --red squiggly at "by", but error line number is following line
             do.dcode,
    ds.SERIALNO,  
    ds.BASECOMPONENTCODE,
    TO_CHAR(strt.DLOCALECRTDT,'MON'),
    do.METRICVALUE; 

Answer 1

显而易见的是，

and 
    Group by  --red squiggly at "by", but error line number is following line
     do.dcode,

AND 单独做什么？将其删除。