我有一个查询需要对其他2列为true的列进行计数。当“DealerName”如“%MINI%”和“DealerContact_Y”=1时，我需要计算“DealerName”但我不确定语法。此查询产生错误SELECTDealerName,count(DealerShipId)asdealersContacted,CASEWHENDealerNameLIKE"%MINI%",WHENDealerContact_Y=1THENCount(DealerContact_Y)ENDasMini_contacted_yes,Campaign,DealerIdFROMtblsummaryResults