Experiment3-labwork

SELECT Deptno, COUNT(*) AS no_of_employees FROM Emp GROUP BY DeptNo;

SELECT avg(sal),COUNT(*) AS lok_jon,DeptNo FROM Emp  GROUP BY DeptNo HAVING lok_jon>5 ;


SELECT Job FROM Emp GROUP BY Sal  HAVING Sal>=5000;
SELECT job FROM Emp WHERE Sal>=5000


SELECT deptno,SUM(sal) AS total,avg(sal) AS Avg,COUNT(*) AS lok_jon FROM Emp GROUP BY DeptNo;



SELECT job,COUNT(*) AS lok_jon FROM Emp  GROUP BY job ORDER BY lok_jon DESC;

SELECT SUM(sal) AS total_salary,MIN(sal) AS minimum_salary,MAX(sal) AS maximum_salary,job FROM Emp GROUP BY Job;

SELECT avg(sal),Job FROM Emp GROUP BY Job HAVING Job!='Manager'

SELECT Job,deptno,SUM(Sal) AS total_sum,MAX(sal) AS max_sal,MIN(Sal) AS min_sal,avg(sal) AS avg_sal FROM Emp GROUP BY job HAVING deptno=20

SELECT job,deptno,SUM(sal) AS total_salary,MAX(sal) AS maximum_salary,MIN(sal) AS minimum_salary,avg(sal) AS avg_salary FROM Emp GROUP BY job HAVING deptno=20 AND avg(sal)>1000






SELECT DeptNo,COUNT(Ename) AS lok_jon FROM Emp GROUP BY DeptNo;
SELECT avg(sal) FROM Emp GROUP BY DeptNo HAVING COUNT(Ename)>5;
SELECT Job FROM Emp WHERE Sal>=5000;
SELECT DeptNo,SUM(Sal) total_salary_payable FROM Emp GROUP BY DeptNo;
SELECT Job,COUNT(Ename) FROM Emp GROUP BY Job ORDER BY COUNT(Ename) DESC;
SELECT SUM(Sal),MAX(Sal),MIN(Sal),Job  FROM Emp GROUP BY Job;
SELECT avg(Sal),Job FROM Emp GROUP BY Job HAVING Job!="Manager";
SELECT SUM(Sal),MIN(sal),avg(Sal),Job FROM Emp WHERE DeptNo=20 GROUP BY Job;
SELECT  SUM(Sal),MAX(Sal),MIN(Sal),avg(Sal),DeptNo FROM Emp WHERE DeptNo=20 GROUP BY Job HAVING avg(sal)>1000;