Questão 833558

SELECT SUM (*)

FROM contrato

WHERE situacao IN 'ATIVO'

AND ano= 2023;

SELECT AVG (*)

FROM contrato

WHERE situacao = 'ATIVO'

AND ano= 2023;

SELECT COUNT (*)

FROM contrato

WHERE situacao IN 'ATIVO'

OR ano= 2023;

SELECT MAX (*)

FROM contrato

WHERE situacao = 'ATIVO'

OR ano= 2023;

SELECT COUNT (*)

FROM contrato

WHERE situacao = 'ATIVO'

AND ano= 2023;