SELECT
    COALESCE(sum(total_bruto), 0)
FROM
    venda_cf AS v
    INNER JOIN item_venda_cf AS iv ON (iv.id_venda_cf = v.id_venda_cf)
    INNER JOIN item AS i ON (i.id_item = iv.id_item)
    INNER JOIN movimento_venda_terminal AS mv ON (
        v.id_movimento_venda_terminal = mv.id_movimento_venda_terminal
    )
WHERE
    v.id_cliente = CAST(16692656 AS BIGINT)
    AND v.cancelada = 'N'
    AND iv.cancelado = 'N'
    AND mv.id_empresa IN (
        SELECT
            id_empresa
        FROM
            sis_empresa se
        WHERE
            se.guid_empresa IN (
                        '428FE6893116415A9E8492A4E4389FDC',
                        '58F6191039094B118F8FA138D3571059',
                        'A17799B432C14F04AAB0278CEE9F3AB1',
                        'AE167ECCFDBF4434A7688C9B5EFFE988',
                        'B532F21B0B9D41B29EAE1FE0B223A805',
                        'F2CA336B72CC45C9B7A504374B44FA77',
                        'F75A07CBC0354BCF8E88411CF5F1B0D0'
                    )
    )
    AND DATE_PART('MONTH', CAST(v.data_cupom AS DATE)) = DATE_PART('MONTH', CAST('2020-01-28' AS DATE))
    AND DATE_PART('YEAR', CAST(v.data_cupom as date)) = DATE_PART('YEAR', CAST('2020-01-28' AS DATE))