My question is not about a specific language but rather how to solve a problem.
How can I generate random numbers but with different probabilities of coming out, for example,
5 --> 63%
10 --> 29.99%
25 --> 7%
50 --> 0.01%
80 --> 0.0001%
The percentages are taken from a game as an example, nothing more.
I got stuck with a script, I show you what I have so far.
I have two tables, historial_numerosand historial_loterias
I have to count the ones that have the column cod=1, the problem arises, that they can have different codes for each lottery.
Where I get stuck is that I need him to id_historial_numero =7mark only one row, not two, in the example I have, only the row with the
cod=1
In the last image I leave the query I have so far.
I thank you in advance for your help.
