title: How to calculate sal of employe whose name starts with a,b,c.....?
body: <pre><code>create table Emp(emp_name varchar(20),emp_sal int)
  
  insert into Emp values
  ('amit',100),('animesh',200),('ashish',300),('ashok',400),
  ('ramesh',500),('ratan',600),('rajesh',700),
  ('lokesh',300),('lalit',900),('lakhan',800)
  </code></pre>
  
  <blockquote>
    <p>Can i calculate sum of the salary of employees whose name starts with 'A', 'R', 'L' and Even I want it show in table with a unique id like </p>
  </blockquote>
  
  <pre><code>emp_id         total_sal
   A               1000
   R               1800
   L               2000
  </code></pre>
  
  <blockquote>
    <p>I have tried like this </p>
  </blockquote>
  
  <pre><code>select sum(emp_sal)as from emp where emp_name like 'a%'
  </code></pre>
  
  <blockquote>
    <p>but dont know what to do next</p>
  </blockquote>