select.sql

1)
select nome, salario, salario * 1.15 as "salário previsto" from professor


2)
select depto.descricao, cargo.descricao, sum(salario), max(salario), min(salario), avg(salario) from professor 
join depto on (depto.codigo = professor.depto)
join cargo on (cargo.codigo = professor.cargo)
group by depto.descricao, cargo.descricao
order by depto.descricao, cargo.descricao

3)
select nome, cargo.descricao, depto.descricao, salario from professor
inner join cargo on (cargo.codigo = professor.cargo)
inner join depto on (depto.codigo = professor.cargo)
order by depto.descricao, cargo.descricao

4)
select d.codigo, d.descricao, count(p.codigo) from professor p, depto d
where (d.codigo = p.depto)
group by d.codigo, d.descricao having count(p.depto) > 0

5)

select nome, salario, decode(depto, 1, salario * 1.21,
										 2, salario * 1.18,
										 3, salario * 1.15,
										 salario * 1.10) salario_simulado, decode(depto, 1, '21%', 2, '18%', 3, '15%', '10%') percentual
from professor

6)
select distinct d.codigo, d.descricao from professor p, depto d
where d.codigo not in (select d.codigo from professor p, depto d where d.codigo = p.depto group by d.codigo)