SQLize Online / PHPize Online  /  SQLtest Online

SELECT REGION, BRANCH, SALE, SALE_PREV_YR, TXN_CNT, TXN_CNT_PREV_YR, WEEK_ISO_ID, OPRT_SUM_TZ, 1 -( CP_SUM_TZ - OPSUM_BONUS - COMM_COMP_OUT_BILL + OPSUM_LOGISTIC )/ nullifzero(OPSUM) AS kom_m_l FROM V_WHS LEFT JOIN PRD_VD_DM.V_LFL_WHS_WEEK ON V_WHS.WHS_ID = PRD_VD_DM.V_LFL_WHS_WEEK.WHS_ID LEFT JOIN PRD_VD_DM.V_RESP_LOST_WK ON V_WHS.WHS_ID = PRD_VD_DM.V_RESP_LOST_WK.RESP_WHS_ID AND PRD_VD_DM.V_LFL_WHS_WEEK.WEEK_ISO_ID = PRD_VD_DM.V_RESP_LOST_WK.WEEK_ID_2 LEFT JOIN PRD_VD_PRICING.V_AUM_WHS_WEEK ON V_WHS.WHS_ID = PRD_VD_PRICING.V_AUM_WHS_WEEK.WHS_ID AND PRD_VD_DM.V_LFL_WHS_WEEK.WEEK_ISO_ID = PRD_VD_PRICING.V_AUM_WHS_WEEK.WEEK_ID_2 WHERE WEEK_ISO_ID BETWEEN 5 AND 6 AND FRMT = ‘ММ’ OR FRMT = ’МК’ OR FRMT = ’ГМ’ AND WORKING = 1