SELECT
    colIP,
    SUM(colPartitionSize) as size,
    SUM(colPartitionFree) as free
  FROM table_name
  GROUP BY colIP