Find average salary of employees for each department and order employees within a department by age.

Input:

Output:

Solution:

create table agedept (Name varchar(20),Age integer,Department varchar(20),Salary integer);

insert into agedept values ("Ram",20,"Finance",50000),("Sudeep",25,"Sales",30000),("Suresh",22,"Finance",50000),("Pradeep",28,"Finance",20000),("Iqbal",22,"Sales",20000);

select Department,avg(Salary) as avg_salary from agedept group by Department order by Name,Age;