title: How to add a subtotal row in sql
body: <p>I have a table with following data:</p>
  
  <pre><code>Name Score
  A     2
  B     3
  A     1
  B     3
  </code></pre>
  
  <p>I want a query which give the following output.</p>
  
  <pre><code>Name Score
  A     2
  A     1
  Subtotal 3
  B    3
  B    3
  Subtotal 6
  </code></pre>
  
  <p>Please help me with an SQL code</p>