title: How to SUM two row with the same id
body: <p>I have the database below its table name is marked,</p>
  
  <p><img src="https://i.stack.imgur.com/7NQkW.png" alt="img"></p>
  
  <p>please help me a code to create another table below</p>
  
  <p><img src="https://i.stack.imgur.com/ewLrK.png" alt="Img1"></p>
  
  <pre><code>SELECT [ID] , sum([physics])
  FROM [mark]
  GROUP BY [ID]
  </code></pre>