Questões de Banco de Dados para Concurso

SELECT AVG(r.valor_base) AS Media_Salario, s.nome AS Setor, YEAR(p.data) AS Ano, MONTH(p.data) AS Mes FROM Pagamento p INNER JOIN Funcionario f ON p.funcionario_id = f.id INNER JOIN Setor s ON f.setor_id = s.id INNER JOIN Rubrica r ON p.rubrica_id = r.id WHERE r.debito_credito = 'C' GROUP BY Setor, Ano, Mes;

SELECT AVG(r.valor_base) AS Media_Salario, s.nome AS Setor, EXTRACT(YEAR FROM p.data) AS Ano, EXTRACT(MONTH FROM p.data) AS Mes FROM Pagamento p
INNER JOIN Funcionario f ON p.funcionario_id = f.id INNER JOIN Setor s ON f.setor_id = s.id INNER JOIN Rubrica r ON p.rubrica_id = r.id WHERE r.debito_credito = 'C' GROUP BY Setor, Ano, Mes;

SELECT AVG(r.valor_base) AS Media_Salario, s.nome AS Setor, YEAR(p.data) AS Ano, MONTH(p.data) AS Mes FROM Pagamento p
INNER JOIN Funcionario f ON p.funcionario_id = f.id INNER JOIN Setor s ON f.setor_id = s.id INNER JOIN Rubrica r ON p.rubrica_id = r.id WHERE r.debito_credito = 'C' GROUP BY s.nome, YEAR(p.data), MONTH(p.data);

SELECT AVG(r.valor_base) AS Media_Salario, s.nome AS Setor, to_date(‘yyyy’, p.data) AS Ano, to_date(‘mm’, p.data) AS Mes FROM Pagamento p INNER JOIN Funcionario f ON p.funcionario_id = f.id INNER JOIN Setor s ON f.setor_id = s.id INNER JOIN Rubrica r ON p.rubrica_id = r.id WHERE r.debito_credito = 'C' GROUP BY s.nome, to_date(‘yyyy’, p.data), to_date(‘mm’, p.data);