SELECT ename,12*sal
FROM emp; //ZAD 3


SELECT ename,12*(sal+250)
FROM emp; //ZAD4

SELECT ename,12*sal "Placa Roczna"
FROM emp; //ZAD 6

SELECT 'Pracownik ' || ename || ' o numerze ' || Empno "Zatrudniony"
FROM emp; //ZAD 7


SELECT ename, job, dname, loc, emp.deptno ed, dept.deptno dd
FROM emp JOIN dept ON emp.deptno = dept.deptno
ORDER BY ename; //ZAD 12

SELECT ename, job, sal, deptno
FROM emp
ORDER BY deptno ASC, sal DESC; //ZAD 15

SELECT ename, Empno, job, sal, deptno
FROM emp
WHERE job = 'CLERK'; //Czesc 2 zadanie 1

SELECT dname, loc, deptno
FROM dept
WHERE deptno > 20; //Czesc 2 zadanie 2

SELECT ename, job, sal, deptno
FROM emp
WHERE sal Between 1000 AND 2000; //Czesc 2 zadanie 4

SELECT *
FROM emp
WHERE mgr = '7902' OR  mgr = '7566' OR mgr = '7788'; //Czesc 2 zadanie 5

SELECT ename, job, sal, deptno
FROM emp
WHERE ename LIKE 'S%'; //Czesc 2 zadanie 6

SELECT ename, empno, loc, dname
FROM emp, dept
ORDER BY ename ASC; //Czesc 3 zadanie 3

SELECT ename, job , loc
FROM emp, dept
WHERE loc = 'DALLAS'; //Czesc 3 zadanie 7