select dname, loc
inner join
from dept;

select mgr, min(sal)
from emp
where mgr is not null and sal > 1000
group by mgr
order by min(sal) desc;

select (MAX(sal) - MIN(sal)) as "Diferenta"
from scott.emp;

select count(mgr) as "Numar Manageri"
from scott.emp;