Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement