SELECT number,SUM(state) FROM table GROUP BY SUBSTR(number,1,5) HAVING SUM(state)=0
SELECT number,count(number) FROM table WHERE state='空闲' GROUP BY SUBSTR(number,1,5) HAVING count(number)=1000
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧