A SELECT F.nómeFun AS Nome Funcionario, F.telefonerun AS Telefone, D.nomeDep ASNome Departamento FROM usuario U OUTER JOIN funcionario F ON U.emailFun = F.emailrun OUTERJOIN departamento D ON F.idDep = D.idDep WHERE U.senhaUsu = 'senha4';
B SELECT F.nomeFun AS “Nome do Funcionario", F.telefoneFun AS Telefone, D.nomeDep AS "Nome doDepartamento” FROM usuario U JOIN Funcionario F IN U.emailrFun = F.emailFun JOINdepartamento D IN F.idDep = D.idDep WHERE U.senhaUsu = 'senha4';
C SELECT F.nómeFun AS Nome Funcionario, F.telefonerun AS Telefone, D.nomeDep ASNome Departamento FROM usuario U JOIN funcionario F WHERE U.emailFun = F.emailFun JOINdepartamento D WHERE F.idDep = D.idDep WHERE U.senhaUsu = 'senha4'!;
D SELECT F.nomeFun AS Nome Funcionario, F.telefoneFun AS Telefone, D.nomeDep ASNome Departamento FROM usuario U INNER JOIN funcionario F ON U.emailFun = F.emailrun INNERJOIN departamento D ON F.idDep = D.idDep WHERE U.senhaUsu = 'senha4!;
E SELECT (SELECT nomeFun FROM funcionario WHERE emailFun = (SELECT emailFun FROM usuarioWHERE senhaUsu = 'senha4')) AS Nome do Funcionario, (SELECT telefoneFun FROM funcionarioWHERE emailFun = (SELECT emailFun FROM usuario WHERE senhaUsu = 'senha4')) AS Telefone,(SELECT nomeDep FROM departamento WHERE idDep = (SELECT idDep FROM funcionario WHEREemailrun = (GELECT emailFun FROM usuario HHERE senhaUsu = 'senha4'))) AS Nome DepartamentoFROM dual;