統計表

SELECT     申請網路, CASE WHEN 申請網路 = '1' THEN '校內學術網路' WHEN 申請網路 = '2' THEN '八人用光纖' ELSE '四人用光纖' END AS 類型名稱, 
                      SUM(tCount) AS 人數
FROM         (SELECT     dbo.床位申請_團體.申請網路, COUNT(*) AS tCount
                       FROM          dbo.床位申請_團體 INNER JOIN
                                              dbo.床位申請明細_團體 ON dbo.床位申請_團體.申請序號 = dbo.床位申請明細_團體.申請序號
                       GROUP BY dbo.床位申請_團體.申請網路
                       UNION ALL
                       SELECT     申請網路, COUNT(*) AS tCount
                       FROM         dbo.床位申請明細_個人
                       GROUP BY 申請網路) AS tmp
GROUP BY 申請網路