title: Populate a column based on another column
body: <p>I'm trying to make a table for Exams where it looks like:</p>
  
  <p><code>ExamID | Name | Points | Grade</code></p>
  
  <p>Where Points is equal to some value from 0 to 100. Now I want to automatically set the value of Grade based on the value of Points. IF > 90 Grade=A...</p>
  
  <p><strong>What is the basic syntax for an sql query to do this</strong>? I'll adjust it to my needs afterwards anyway.</p>
  
  <p>Tried playing around with the CASE syntax, but couldn't do it. I'm guessing I should use the UPDATE query, not the INSERT query.</p>