Projekt rejestracji na wakacje

14/09/2020

select ENAME, JOB from emp

select ENAME as name  ,JOB as stanowsiko from emp

______________________________

select * from emp where sal>=1500 AND sal<=3000 order by sal desc;

___________________________

select avg(sal) from emp

_______________________________

select count(*) from emp - liczba recordow

______________________________________

select count(distinct job) from emp

_________________________________

select max(sal) , min(sal) from emp

__________________________________

select sum(sal) from EMP where JOB='MANAGER'

________________________________________

select sum(sal) from EMP where job like 'SAL%'