SQL 将多个通过筛选得到的数据相加

要将多个通过筛选得到的数据相加

数据库的表，对这张表进行查询、筛选等操作

pwr_1>0同时pwr_2>pwr_1,将pwr的和输出。值578

   select 
  case when sum(pwr) is not null
  then SUM(pwr)
  else 0
  end 
  from dbo.test   
  where pwr_1>=0 and pwr_2>pwr_1

pwr_2<=pwr_1 ，将pwr除以2之后合并。值742

  select 
  case when sum(pwr) is not null
  then SUM(pwr/2)
  else 0
  end 
  from dbo.test 
  where pwr_2<=pwr_1

pwr_1<0 。值0

 select 
  case when sum(pwr) is not null
  then 0
  else 0
  end 
  from dbo.test 
  where pwr_1<0

将筛选出来的值相加。值1320

  select (select 
  case when sum(pwr) is not null
  then SUM(pwr)
  else 0
  end 
  from dbo.test   
  where pwr_1>=0 and pwr_2>pwr_1)+
  (select 
  case when sum(pwr) is not null
  then SUM(pwr/2)
  else 0
  end 
  from dbo.test 
  where pwr_2<=pwr_1)+
  (select 
  case when sum(pwr) is not null
  then 0
  else 0
  end 
  from dbo.test 
  where pwr_1<0)