+----+---------+------------+-----+-------+
| id | part_id | storage_id | qty | price |
+----+---------+------------+-----+-------+
|  1 |      1  |      6     |  1  | 2500  |
|  2 |      3  |      2     |  3  |  250  |
|  3 |      4  |     11     |  4  | 1100  |
|  4 |      4  |      6     |  3  | 1100  |
|  5 |      8  |      6     |  2  |  400  |
|  6 |     10  |      8     |  1  |  150  |
|  7 |     11  |      6     |  1  |  450  |
|  8 |     19  |     11     |  1  |  800  |
|  9 |     24  |      2     |  1  |  350  |
| 10 |     24  |      6     |  6  |  350  |
| 11 |     32  |      2     |  4  | 2100  |
| 12 |     32  |      6     |  9  | 2100  |
+----+---------+------------+-----+-------+

+------------+-------+
| storage_id |  sum  |
+------------+-------+
|       2    |  9500 |
|       6    | 28050 |
|       8    |   150 |
|      11    |  5200 |
+------------+-------+

SELECT 
  storage_id,  sum(qty * price) AS RowTotal
FROM 
  warehouse_stock
GROUP BY 
  storage_id;