SQL_Kwerendy_apin

--1
SELECT`DEPTNO`,`ENAME`,`MGR` FROM `emp`;

--2
SELECT * FROM `emp`;

--3
SELECT `ENAME`,`SAL`*12 AS roczna FROM `emp`;

--4
SELECT `ENAME`,(`SAL`+250)*12 AS roczna FROM `emp`;

--5
SELECT `SAL`*12 AS Roczna FROM `emp`;

--6
SELECT `SAL`*12 AS `Placa Roczna` FROM `emp`;

--7
SELECT CONCAT(`EMPNO`, ' ', `ENAME`) AS zatrudniony FROM `emp`;

--8
SELECT CONCAT(`EMPNO`, ' ', `ENAME`, ' ', 'Pracownik pracuje w dziale nr ') AS zatrudniony, `DEPTNO` AS dzial FROM `emp`;

--9
SELECT `SAL`*12 + IF(`COMM` IS NOT NULL, `COMM`, 0) AS roczna FROM `emp`;

--10
SELECT `DEPTNO` FROM `emp`;

--11
SELECT DISTINCT `DEPTNO` FROM `emp`;

--12
SELECT DISTINCT `deptno`,`job` FROM `emp`;

--13
SELECT * FROM `emp` ORDER BY `ENAME` ASC;

--14
SELECT * FROM `emp` ORDER BY `HIREDATE` DESC;

--15
SELECT * FROM `emp` ORDER BY `DEPTNO` ASC, `SAL` DESC;

--16
SELECT `ENAME`, `EMPNO`, `JOB`, `SAL`, `DEPTNO` FROM `emp` WHERE `JOB`='CLERK';

--17
SELECT `DNAME`, `DEPTNO`FROM `DEPT` WHERE `DEPTNO`>20;

--18


--19
SELECT * FROM `emp` WHERE `SAL` BETWEEN 1000 AND 2000;

--20
SELECT * FROM `emp` WHERE `MGR` = 7902 OR `MGR` = 7566 OR `MGR` = 7788;

--21
SELECT * FROM `emp` WHERE LEFT(`ENAME`,1) = 'S';

--22
SELECT * FROM `emp` WHERE CHAR_LENGTH(`ENAME`) = 4;

--23
SELECT * FROM `emp` WHERE `MGR` IS NULL;

--24
--ewentualnie NOT BETWEEN
SELECT * FROM `emp` WHERE `SAL` < 1000 OR `SAL` > 2000;

--25
SELECT * FROM `emp` WHERE LEFT(`ENAME`, 1) != 'M';

--26
SELECT * FROM `emp` WHERE `MGR` IS NOT NULL;

--27
SELECT * FROM `emp` WHERE `JOB` = 'CLERK' AND `SAL` BETWEEN 1000 AND 2000;

--28
SELECT * FROM `emp` WHERE `JOB` = 'CLERK' OR `SAL` BETWEEN 1000 AND 2000;

--29
SELECT * FROM `emp` WHERE `JOB` = 'MANAGER' AND `SAL` > 1500 OR `JOB` = 'SALESMAN';

--30
SELECT * FROM `emp` WHERE `JOB` = 'MANAGER' OR `JOB` = 'SALESMAN' AND `SAL` > 1500;

--31
SELECT * FROM `emp` WHERE `JOB` = 'MANAGER' OR `JOB` = 'CLERK' AND `DEPTNO` = 10;

--32
SELECT * FROM `SALGRADE`;

--33
SELECT * FROM `DEPT`;

--34
SELECT * FROM