SELECT ICCID,gatewaySN,gatewayName,project,operator,setMeal,surplusFlow,serviceFlow,expireTime,activateTime,projectPrincipal FROM simOrm WHERE activateTime < 1704038400000 AND activateTime > 1 AND simManufacturer = 2 AND operator = '移动' AND setMeal LIKE '%2G%' AND serviceFlow > 100
SELECT project,COUNT(projectID) FROM simOrm WHERE activateTime < 1704038400000 AND activateTime > 1 AND simManufacturer = 2 AND operator = '移动' AND setMeal LIKE '%2G%' GROUP BY project