Skip to content

Instantly share code, notes, and snippets.

@ehzawad

ehzawad/class.sql

Last active February 17, 2016 06:47
Show Gist options
  • Save ehzawad/ec1d065c753d4d108129 to your computer and use it in GitHub Desktop.
Save ehzawad/ec1d065c753d4d108129 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
class.sql
1. select max(sal), min(sal), avg(sal) , count(empno) from emp where deptno=20;
2. select max(sal), min(sal), avg(sal) ,count(empno) from emp where job='SALESMAN';
3. select max(sal), min(sal), avg(sal), comm from emp where comm>=0 group by comm;
4. select count(empno), job from emp group by job;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment