By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 1 AS move_id, 1 AS item_id, 10 AS quantity, 100 AS [value] UNION ALL
SELECT 1, 2, 20, 150 UNION ALL
SELECT 1, 3, 30, 200
),
cte AS (
SELECT *, MIN(quantity) OVER (PARTITION BY move_id) min_quantity
FROM yourTable
)
SELECT
move_id,
MIN(quantity) AS quantity,
SUM([value] * min_quantity / quantity) AS value
FROM cte
GROUP BY
move_id;
| move_id | quantity | value |
|---|---|---|
| 1 | 10 | 241 |