title: sqlite - How to select rows based on probability via integer value?
body: <p>In my database, I have a list of bands along with a popularity column, which is incremented or decremented when a user, on a webpage, presses a like or dislike button respectively. I want to select bands based on this popularity column. The probability that a band is selected depends on this popularity column, which is an integer value, and not a decimal value like 0.3, 0.1, which should make sense if one is working with probability, but in my case, I don't think it's possible. Example of my table:</p>
  
  <pre><code>Bands        probability
  Led Zeppelin    79
  Megadeth         4
  Queen           37
  Aerosmith       20
  Guns N Roses   103
  </code></pre>
  
  <p>Based on this, Guns N' Roses should have a highest chance of being selected, while Megadeth has the lowest chance of being selected, while other bands also each have their own chances of being selected. I'll be selecting 10 bands from a list of 2000.</p>