example (SQL)

create table emp(
     id int,
     name varchar2(20),
     dno int,
     h_date date,
     job varchar2(20),
     sal int
     );
     
insert into emp values(1, 'sai pavan',22, '29-06-2022', 'manager', 6000000);
insert into emp values(2, 'rao', 25,'29-06-2021', 'sales manager', 60000);
insert into emp values(3, 'racha', 22,'29-06-2020', 'manager', 6000);
insert into emp values(4, 'konda', 24,'29-06-2019', 'project mentor', 80000);
insert into emp values(5, 'venkat', 25,'29-06-2018', 'sales manager', 100000);
insert into emp values(6, 'sujatha', 20,'29-06-2017', 'employee2', 100001);

select job , sum(sal) from emp
group by job;