利用这个表 （表名随便）写一个存储 要求按月份科室统计病危病重人数 病危病重的条件是 yznr列数值等于1

CREATE PROCEDURE T_BM_CriticallyRun_Query
@Office NVARCHAR(32)=NULL,
@Month INT=0
WITH ENCRYPTION
AS

BEGIN

SELECT COUNT(病危人数),
字段 as 显示名称,
.......
FROM 表 WITH (NOLOCK)
WHERE KSMC=@Office AND KSRQ=@Month AND yznr=1
GROUP BY KSRQ,KSMC
END