Relatório personalizado - Gráfico de horário com a quantidade de vendas

SELECT
    CAST(V.DATA_EMISSAO AS DATE) AS DATA_VENDA,

    EXTRACT(HOUR FROM V.DATA_EMISSAO) || ':00' AS HORARIO,

    CAST(CAST(V.DATA_EMISSAO AS DATE) AS VARCHAR(10))
        || ' '
        || EXTRACT(HOUR FROM V.DATA_EMISSAO)
        || ':00'
    AS DATA_HORA_VENDA,                                                                    

    COUNT(V.ID) AS TOTAL_VENDAS                                  

FROM VENDAS V

WHERE
    V.STATUS = 'Venda faturada'
               
    AND V.DATA_EMISSAO >= '2026-04-01'
    AND V.DATA_EMISSAO < '2026-05-27'

GROUP BY
    CAST(V.DATA_EMISSAO AS DATE),
    EXTRACT(HOUR FROM V.DATA_EMISSAO)

ORDER BY
    DATA_HORA_VENDA ASC;

1004.fr3