SELECT ename+'works like '+job AS [employee],'IN DEPARTMENT',deptno
from emp;

SELECT ename,12*SAL+ISNULL(comm,0) AS [ethsios misthos & promhteia],comm
from emp
where sal>isnull(comm,0)
order by sal DESC,ename ASC;

SELECT ename
from emp
where ename like '__R%';

SELECT ename
from emp
where job NOT LIKE 'MANAGER"';

SELECT dname
from dept
where deptno=10 OR deptno=30;

SELECT dname
from dept
where deptno in(10,30);

Select distinct job
from emp;

SELECT *
from emp
where deptno in(10,20)
order by ename DESC;

SELECT ename
from emp
where mgr in(7902,7566,7788);

Select ename
from emp
where ename like 'S%' OR ename like '____';

SELECT ename
from emp
where sal not between 1000 and 2000;

SELECT ename
from emp
where job not like 'M%';

SELECT ename,job,sal
from emp
where MGR is not null;

Select ename
from emp
where job like 'CLERK' and Sal between 100 and 2000;