-- create a table
CREATE TABLE employee (
id number(10),
name varchar2(20),
    salary number(10)
);
--insert into employee
insert into employee
    (id,name,salary)values
    (25210005,'Mohit',50000);
insert into employee
(id,name,salary)values
(25210016,'hari',45000);
insert into employee
(id,name,salary)values
(25210029,'mani',40000);
insert into employee
(id,name,salary)values
(25210036,'pintu',35000);
insert into employee
(id,name,salary)values
(25210030,'abhi',30000);
insert into employee
(id,name,salary)values
(25210040,'eswar',25000);
--select from employee
select *from employee;
select SUM(salary)FROM(Employee);
select AVG(salary)FROM(Employee);
select MAX(salary)FROM(Employee);
select MIN(salary)FROM(Employee);
select COUNT(salary)FROM(Employee);