摘要：
selecta.acct_week,a.BRANCH_CD,a.store_cd,a.item_cd selecta.acct_week,a.BRANCH_CD,a.store_cd,a.item_cd,a.jan,a.sales_cnt,a.POS_CUSTOMER_CNT,a.PI,a.GoalPI,round(a.GoalPI*a.POS_CUSTOMER_CNT/1000,0) as goal_sales_cnt,(case when (a.PI='' or a.PI=0 or a.PI is null) then '-' when a.PI>(a 阅读全文
