Return minimum value for each row

Hello,

I have two tables, joined by case number

1st table

2nd table

I have tried using the MIN function but it returns the min value of the 1st table regardless the case number. Instead I need it for each case number.

Do you know how to do this?

Thank you!!