title: How to get count number in table with same code?
body: <pre><code>Table 1
  Primary key = id
  
  id |kpi_code | result_date | data|
  
  1  |KPI1     | 11/13/2019  | 100 |
  2  |KPI1     | 11/14/2019  | 200 |
  3  |KPI2     | 11/13/2019  | 50  |
  4  |KPI2     | 11/14/2019  | 100 |
  
  Expecting Output:
  
  KPI1 : 300
  KPI2 : 150
  
  </code></pre>
  
  <p>I'm looking for the solution to get the <code>kpi_code</code> and calculate the total data of each different <code>kpi_code</code>. </p>