SELECT empresa, COUNT(*) AS total_beneficios

FROM beneficios

WHERE data_concessão BETWEEN SYSDATE AND SYSDATE - 365

GROUP BY empresa

HAVING COUNT(*) > 5;

SELECT empresa, COUNT(*) AS total_beneficios

FROM beneficios

WHERE data_concessão <= ADD_MONTHS(SYSDATE, -12)

GROUP BY empresa

HAVING COUNT( ) > 5;

SELECT empresa, COUNT(*) AS

total_beneficios FROM beneficios

WHERE data_concessão >= ADD_MONTHS(TRUNC(SYSDATE), -12)

GROUP BY empresa

HAVING COUNT(*) > 5;

SELECT empresa, COUNT(*) AS total_beneficios

FROM beneficios

WHERE EXTRACT(YEAR FROM data_concessão) := EXTRACT(YEAR FROM SYSDATE)-1

GROUP BY empresa

HAVING COUNT(*) > 5;

SELECT empresa, SUM(beneficio) AS total_beneficios

FROM beneficios

WHERE data_concessão >= ADD_MONTHS(SYSDATE, -12)

GROUP BY empresa

HAVING SUM(beneficio) > 5;