CREATE OR ALTER VIEW V_SUMCSTM(
    ID,
    V_CSTM_NAME,
    V_SUM)
AS
SELECT CSTM.ID,
            CSTM.SHRTNAME,
            COALESCE(sum(SCCNT.V_SUM), 0)
                                                                            
FROM CUSTOMERS CSTM, V_SUMCCNT SCCNT

WHERE SCCNT.ID_CSTM = CSTM.ID

GROUP BY
       CSTM.ID,
       CSTM.SHRTNAME
;

CREATE OR ALTER VIEW V_SUMCCNT(
    ID,
    ID_CSTM,
    V_CCNT_NAME,
    V_SUM)
AS
SELECT CCNT.ID,
       CCNT.ID_CUSTOMER,
       CCNT.V_CONTACTNAME,
       COALESCE((select sum(V_SUM) from V_ORDER where ID_CUSTCONTACT = CCNT.ID and V_RECORDSTATUS in (4)), 0)

FROM V_CUSTCONTACT CCNT
;

CREATE OR ALTER VIEW V_SUMCSTM(
    ID,
    V_CSTM_NAME,
    V_SUM)
AS
SELECT CSTM.ID,
       CSTM.SHRTNAME,
       COALESCE(sum((select sum(V_PROFIT) from V_ORDER where ID_CUSTCONTACT = CCNT.ID and V_RECORDSTATUS in (4))), 0)
                                                                            
FROM CUSTOMERS CSTM, V_ORDER ORD

WHERE ORD.ID_CUSTOMER = CSTM.ID

GROUP BY
       CSTM.ID,
       CSTM.SHRTNAME
;

COALESCE((select sum(V_SUM) from V_ORDER where ID_CUSTCONTACT = CCNT.ID and V_RECORDSTATUS in (4) AND V_SALEDATE >= '01.12.2018'), 0)

SELECT * 
FROM V_SUMCCNT
WHERE ID_CSTM = :ID  
ORDER BY V_SUM DESC