weighted_winner.sql

-- winning_count is a random number between 0 and 1
-- times the sum of the weights
SELECT id
FROM (
  SELECT id, SUM(weight) OVER (ORDER BY id) S
  FROM entries WHERE drawing_id = #{@drawing.id}
) Q
WHERE S >= winning_count
ORDER BY id
LIMIT 1;