title: How can I calculate what percentile each value of a column is in? (Spark SQL)
body: <p>I have the following table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Person</th>
  <th>Score</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>3.5</td>
  </tr>
  <tr>
  <td>2</td>
  <td>6.5</td>
  </tr>
  <tr>
  <td>3</td>
  <td>2.1</td>
  </tr>
  <tr>
  <td>4</td>
  <td>8.3</td>
  </tr>
  <tr>
  <td>5</td>
  <td>5.4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have multiple people, each with just one score each. Each score is on a 10.0 point scale.</p>
  <p>I would like to find out which percentile each person's score stands in. So a score of 6.5 for person 2, for example, is in the x percentile of people, and so on.</p>
  <p>Couldn't figure out the syntax, would love some help.</p>