sql - 如何在SQL中计算多行

Question

我有一个看起来像这样的表格:

ComputerID | Free_Space | Disk_Size
------------------------------------------
Computer1  | 10         | 15
Computer1  | 10         | 10
Computer1  | 05         | 10
Computer2  | 05         | 05
Computer2  | 05         | 10
Computer3  | 11         | 15
Computer3  | 04         | 05

我需要实现这样的目标:

ComputerID | Free_Space | Disk_Size
------------------------------------------
Computer1  | 25         | 35
Computer2  | 10         | 15
Computer3  | 15         | 20

我尝试过类似的方法，但没有成功。

 SELECT ComputerID,
 SUM(free_space/1000000000) AS 'Total Free Space',
 SUM(disk_size/1000000000) AS 'Total Size'
 FROM myTable
 ORDER BY ComputerID

任何帮助将不胜感激。

Answer 1

SELECT ComputerID,
SUM(free_space/1000000000) AS 'Total Free Space',
SUM(disk_size/1000000000) AS 'Total Size'
FROM myTable
GROUP BY ComputerID