6-2-18.sql

select * from emp33;
update dept33 
set DNAME = 'Accounting' 
where DNO = 10;
delete from dept33 where DNO = 60;

select ENO, ENAME from emp33 where MANAGER = null;

select ENO, ENAME from emp33 order by ENAME, ENO;
select * from emp33, dept33 where emp33.DNO = dept33.DNO;

select ENAME, DNAME from emp33 natural join dept33 where HIRE_DATE > '01/JAN/81';
select dname, dno, count(*) from emp33 natural join dept33 group by dname, dno having count(*) > 2;

//nested
select ename from emp33 where dno in (select dno from emp33 group by dno having count(*) > 1) order by ename;