Modeling die rolls in Postgres (basic stat functions)
In many cases, it's better to do statistical calculations from the database instead of from your application. Even some basic stat functions aren't standardized in ANSI SQL. Here are some patterns you can use.