Questões de Concurso

SELECT empresa, COUNT(*) AS total_beneficios

FROM beneficios WHERE data_-concessao BETWEEN SYSDATE AND SYSDATE - 365

GROUP BY empresa

HAVING COUNT(*) > 5;

SELECT empresa, COUNT(*) AS total_-beneficios

FROM beneficios

WHERE data_-concessao <= ADD_MONTHS (SYSDATE, -12)

GROUP BY empresa

HAVING COUNT( ) > 5;

SELECT empresa, COUNT(*) AS

total_beneficios FROM beneficios

WHERE data_-concessao >= ADD_MONTHS (TRUNC(SYSDATE), -12)

GROUP BY empresa

HAVING COUNT(*) > 5; 

SELECT empresa, COUNT (*) AS total_-beneficios

FROM beneficios

WHERE EXTRACT (YEAR FROM data_concessao) := EXTRACT(YEAR FROM SYSDATE) - 1

GROUP BY empresa

HAVING COUNT(*) > 5;

SELECT empresa, SUM(beneficio) AS total_beneficios

FROM beneficios

WHERE data_concessao >= ADD_MONTHS (SYSDATE, -12)

GROUP BY empresa

HAVING SUM (beneficio) > 5;

SELECT COUNT(*)

FROM audiencias

WHERE tipo_processo = 'RESCISÃO CONTRATUAL'

AND data_audiencia >= MAKE_INTERVAL (months := 3);

SELECT COUNT(*)

FROM audiencias

WHERE tipo_processo = 'RESCISÃO CONTRATUAL'

AND data_audiencia >= CURRENT_DATE - INTERVAL '3 MONTH';

SELECT COUNT (*) AS total

FROM audiencias

WHERE tipo_processo = 'RESCISÃO CONTRATUAL'

AND data_audiencia >= CURRENT_DATE - '90 DAYS';

SELECT COUNT (*)

FROM audiencias

WHERE tipo_processo = 'RESCISÃO CONTRATUAL'

AND data_audiencia >= NOWDATE() - INTERVAL '3 MONTH';

SELECT COUNT (*)

FROM audiencias

WHERE tipo_processo = 'RESCISÃO CONTRATUAL'

AND data_audiencia >= DATE_TRUNC('MONTH', NOW()) - '3 MONTHS';