select catday.MFG_ORG_CD
, catday.MFG_ITEM_CLASS_ID
, timehier.BSNS_WK_ID
, sum(catday.NUM_MFG_SKU_ITEMS) as NUM_MFG_SKU_ITEMS
, timehier.WK_TIMESPN
, count(catday.NUM_MFG_SKU_ITEMS) as CNT_DAYS
, count(*) as CNT_TOTAL
from ddr_bs_cls_day_mv catday
, ddr_r_base_day_dn_mv timehier
where timehier.clndr_cd = catday.clndr_cd
and timehier.day_cd = catday.day_cd
group by catday.MFG_ORG_CD
, catday.MFG_ITEM_CLASS_ID
, timehier.BSNS_WK_ID
, timehier.WK_TIMESPN
SELECT CATDAY.MFG_ORG_CD
, CATDAY.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_WK_ID
, SUM(CATDAY.NUM_MFG_SKU_ITEMS) AS NUM_MFG_SKU_ITEMS
, TIMEHIER.WK_TIMESPN
, COUNT(CATDAY.NUM_MFG_SKU_ITEMS) AS CNT_DAYS
, COUNT(*) AS CNT_TOTAL
FROM DDR_BS_CLS_DAY_MV CATDAY
, DDR_R_BASE_DAY_DN_MV TIMEHIER
WHERE TIMEHIER.CLNDR_CD = CATDAY.CLNDR_CD
AND TIMEHIER.DAY_CD = CATDAY.DAY_CD
GROUP BY CATDAY.MFG_ORG_CD
, CATDAY.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_WK_ID
, TIMEHIER.WK_TIMESPN
|
|
|