title: how to write query for this reuslt
body: <p>I have a employee table having column (<strong>empno,enme,salary,deptno</strong>)<br>
  I want to write a query which displays the following table:containing first column </p>
  
  <ul>
  <li>deptno</li>
  </ul>
  
  <p>,second column </p>
  
  <ul>
  <li><p>sum of salaries of the employees of each department whose name start<br>
  with 'A'</p>
  
  <p>and third column </p></li>
  <li><p>total slary of all the employees of that department</p></li>
  </ul>
  
  <p>Any one please help me how to write query for this scenario..?</p>