I wonder if this can be done with SQL...

[GoldenCockerel]

example:

Customer A has these transaction records:

trans_id number_of_points_given
1 1
2 5
3 5
4 2
5 1

The prize that this customer A claims is worth 10 points (prize.number_points_reqd = 10)

So, I only want to delete a number of transaction records where their combined number_of_points_given = prize.number_points_reqd (10), no more, no less