Hello ,
I have reference table which contains category and their max and min value
| Category | Min | Max |
| A | 10 | 15 |
| B | 16 | 20 |
| C | 21 | 25 |
I have another table which contains user category and his ID
I want to assign random value to him based on his category max and min value
User | Category | Value |
| 1 | A | |
| 2 | A | |
| 3 | B | |
| 4 | C | |
| 5 | C | |
Value should be between max and min value of his category
Is there anyway to do it ?
