回答:ELECTCOUNT(BADQTY)FROM DGBINREWORK WHERE MACHINECODE in ('B73','B47','B45','B55','B09','B69','B46','B13','B07','B54','B50','B63','B53','B64','B76','B60','B44','B68','B65','B66','B74','B67','B57','B20','B05','B26','B48','B36','B27','B29')AND REASONCODE='油污'AND TO_CHAR(EVENTTIME,'YYYY-MM-DD')>= ('2021-10-13')AND TO_CHAR(EVENTTIME,'YYYY-MM-DD')<= ('2021-10-13')group by MACHINECODEhaving COUNT(BADQTY)>0