1. SELECT f1.nome FROM funcionario AS f1
WHERE f1.cpf NOT IN(selct d.cpffuncionario FROM dependente AS d)
AND f1.cpf NOT IN (SELECT v.cpffuncionarion FROM vendas AS v)

SELECT f1.nome
FROM funcionario AS f1
WHERE MONTH(f1.datanascimento) <> 4 AND f1.cpf NOT IN(SELECT v2.cpfFuncionario FROM vendas AS v2 JOIN funcionario  AS f2 JOIN produto AS p JOIN produtosvendas AS pv
WHERE v2.cpffuncionario - f2.cpf AND v2.id = pv.idVenda AND p2.id = pv.idproduto
    AND p2.nome LIKE "mesa"


SELECT f1.* FROM funcionario AS f1
JOIN dependente AS d1
WHERE f1.cpf = d1.cpffuncionario AND f1.nome NOT LIKE "%n"  AND f1.cpf IN (SELECT f.cpf FROM funcionario AS f JOIN vendas AS v JOIN produto AS
p JOIN produtosvendas AS pv ON f.cpf = v.cpffuncionario AND v.id = pv.idvENDA AND P.ID - PV.IDPRODUTO GROUP BY f.nome HAVING
SUM(p.valorUnd*pv.qtd)>1900)
GROUP BY f1.nome HAVING COUNT(d1.cpffuncionario)
ORDER BY f1.nome DESC

SELECT f1.nome FROM funcionario, dependentes
WHERE IN(SELECT COUNT(cpffuncionario) > 1 FROM  dependente GROUP BY cpffuncionario) AND f1.nome NOT LIKE '%n%'
AND IN
ORDER BY nome DESC