sqlserver怎么实现同一个表中多个count查询并且分组并且统计总数

可以有两种解决方法， 所需工具：SQL 查询两个count的方法1: SELECT paperName , COUNT (1) AS 总题数 , sum (CASE WHEN statu = 1 THEN 1 ELSE 0 END) AS 审核题数FROM questionGROUP BY paperNme 查询两个count的方法2: select s.总题数, s.审核题数, s.paperNamefrom (select COUNT(1) as 总题数, case