EMP.DEPTNO=DEPT.DEPTNO AND SAL IN(SELECT MAX(SAL)
FROM EMP
GROUP BY DEPTNO); ---
WHERE SAL >=(SELECT AVG(SAL)
FROM EMP); ----
WHERE EMP.DEPTNO=DEPT.DEPTNO AND EMP.SAL=1500; -----
SELECT ENAME + ' pracuje na stanowisku ' + JOB + ' w zespole ' + DEPTNO + 'od')
FROM EMP; ------
WHERE DEPTNO NOT IN(SELECT DEPTNO FROM EMP)
ORDER BY DEPTNO; ------
N.imie J.przedmiot
FROM Uczniowie_dane AS N, Uczniowie_oceny AS J; -----