select *
from projekt,przydzial;

SELECT *
FROM projekt JOIN przydzial;

SELECT *
FROM projekt JOIN przydzial
USING (projektid);

SELECT *
FROM projekt JOIN przydzial
ON projekt.atr1 = przydzial.atr2;



select grade, count(grade)
from emp, salgrade
where sal+ifnull(comm,0)>=losal and sal+ifnull(comm,0) <=hisal
group by grade;




select *
from emp
where sal+ifnull(comm,0) =
	(select max(sal+ifnull(comm,0))
	from emp join dept using(deptno)
	where loc ="NEW YORK");