· 6 years ago · Sep 11, 2019, 08:42 AM
1create table if not exists Employ(id integer, title varchar(100) , sallery int);
2insert into Employ(id, title, sallery) values(1, "kk" , 90000);
3insert into Employ(id, title, sallery) values(1, "Nishank" , 50000);
4insert into Employ(id, title,sallery) values(1, "hemu" , 75000);
5insert into Employ(id, title, sallery) values(1, "CK" , 65500);
6select COUNT(sallery) from Employ;
7select AVG(sallery) from Employ;
8select MAX(sallery) from Employ;
9select SUM(sallery) from Employ;
10select SUM(sallery)/COUNT(sallery) from Employ;
11select MIN(sallery) from Employ;
12
13
14-- Your code here!