MySQL: SELECT with SUM() and COUNT() as new columns
If we assume that 'QtyOfParts' and 'FamilyID' are existing columns in the table  and furthermore, that the other 2 columns are "calculated", then maybe the following query would be helpful (creating some test data first):

create table qf (
  QtyOfParts integer
, FamilyID integer 
);

insert into qf values 
(28, 1), (32, 1), (19, 1), 
(28, 2), (38, 2), (46, 3),
(30, 3), (51, 3), (24, 3);


Thus:

mysql&gt; select * from qf;
+------------+----------+
| QtyOfParts | FamilyID |
+------------+----------+
|         28 |        1 |
|         32 |        1 |
|         19 |        1 |
|         28 |        2 |
|         38 |        2 |
|         46 |        3 |
|         30 |        3 |
|         51 |        3 |
|         24 |        3 |
+------------+----------+
9 rows in set (0.00 sec)


Suggested query:

mysql&gt; select 
    -&gt;   t1.qtyofparts
    -&gt; , t1.familyid
    -&gt; , t2.nbr NumInFamily
    -&gt; , t2.sum FullQtyOfParts 
    -&gt; from qf t1 join ( 
    -&gt;     select 
    -&gt;       familyid
    -&gt;     , count(familyid) nbr
    -&gt;     , sum(qtyofparts) sum
    -&gt;     from qf 
    -&gt;     group by familyid ) t2 on t1.familyid = t2.familyid
    -&gt; ;
+------------+----------+-------------+----------------+
| qtyofparts | familyid | NumInFamily | FullQtyOfParts |
+------------+----------+-------------+----------------+
|         28 |        1 |           3 |             79 |
|         32 |        1 |           3 |             79 |
|         19 |        1 |           3 |             79 |
|         28 |        2 |           2 |             66 |
|         38 |        2 |           2 |             66 |
|         46 |        3 |           4 |            151 |
|         30 |        3 |           4 |            151 |
|         51 |        3 |           4 |            151 |
|         24 |        3 |           4 |            151 |
+------------+----------+-------------+----------------+
9 rows in set (0.00 sec)