问组合不同count(*) sql查询的结果

EN

declare @PicBills table (
    SubDivision     int not null primary key clustered,
    PicBillsCount   int not null
)

declare @TotalBills table (
    SubDivision     int not null primary key clustered,
    TotalBillsCount int not null
)

insert into @PicBills
select 
    gbsdiv ,
    count(*)
from   
    tblgbmain 
where  
    ( gbpicture1 is not null or gbpicture2 is not null ) and gbbatch = 15 
group by 
    gbsdiv;


insert into @TotalBills
select 
    gbsdiv ,
    count(*)
from   
    @PicBills pb
    inner join tblgbmain on gbsdiv = SubDivision
where  
    gbbatch = 15 
group by 
    gbsdiv;

select 
    [sub division]  =   t1.SubDivision  , 
    [total bills]   =   TotalBillsCount , 
    [pic bills]     =   PicBillsCount   , 
    [%]             =   PicBillsCount * 100 / TotalBillsCount  
from   
    @PicBills t1 
    inner join @TotalBills t2 on t1.SubDivision = t2.SubDivision;

SELECT gbsdiv   AS 'Sub Division', 
       Count(*) AS 'Pic Bills' 
INTO   #temp 
FROM   tblgbmain 
WHERE  ( gbpicture1 IS NOT NULL 
          OR gbpicture2 IS NOT NULL ) 
       AND gbbatch = 15 
GROUP  BY gbsdiv 

SELECT t1.[sub division], 
       [total bills], 
       [pic bills], 
       ( ( t1.[pic bills] * 100 ) / t2.[total bills] ) AS '%' 
FROM   #temp t1 
       INNER JOIN (SELECT gbsdiv   AS 'Sub Division1', 
                          Count(*) AS 'Total Bills' 
                   FROM   tblgbmain t 
                   WHERE  EXISTS (SELECT 1 
                                  FROM   #temp te 
                                  WHERE  t.gbsdiv = te.[Sub Division])
                   Group by gbsdiv ) t2 
               ON t1.[sub division] = t2.[sub division1] 

WITH t1 AS (
 SELECT gbsdiv   AS 'Sub Division', 
        Count(*) AS 'Pic Bills' 
        FROM   tblgbmain 
        WHERE  ( gbpicture1 IS NOT NULL 
              OR gbpicture2 IS NOT NULL ) 
        AND gbbatch = 15 
        GROUP  BY gbsdiv
)
SELECT [Sub Division], 
       [total bills], 
       [pic bills], 
       ( ( [pic bills] * 100 ) / [total bills] ) AS '%' 
FROM  t1 
INNER JOIN (
  SELECT gbsdiv   AS 'Sub Division1', 
         Count(*) AS 'Total Bills' 
  FROM   tblgbmain 
  WHERE  EXISTS ( SELECT 1 FROM t1 WHERE gbsdiv=[Sub Division] )
  AND gbbatch = 15
  GROUP BY gbsdiv ) AS t2
ON [Sub Division] = [Sub Division1]