-- dm1yj_tj
SELECT
UniqueID,
GzRq,
YjFlDm,
YjFl,
YjKs,
ExamType,
TjLb,
KdRc,
Kd_Jf_Rc,
Kd_Wc_Rc,
Kd_JfYc_Rc,
Kd_ExamYc_Rc,
AVG_KdSh_Sc,
Time1_Wc_Rate,
Time2_Wc_Rate,
Time3_Wc_Rate,
Time4_Wc_Rate,
Time5_Wc_Rate,
Time6_Wc_Rate,
Yy_Gt_Rc,
ZdYy_Xm_Cnt,
DjRc,
Dj_Wjc_Rc,
JcRc,
JcRs,
Jc_Wwc_Rc,
Avg_Dj_Jc_Sc,
Dj_Jc_Rc,
Dj_Jc_Rc1,
Dj_Jc_Rc2,
XmJe,
Avg_XmJe,
WcRc,
Avg_Jc_Sh_Sc,
Avg_Bg_Sh_Sc,
Time1_Wc_Num,
Time2_Wc_Num,
Time3_Wc_Num,
Time4_Wc_Num,
Time5_Wc_Num,
Time6_Wc_Num,
Time_Wc_Den
FROM dw3yj_tj
WHERE GzRq>=CURRENT_DATE -INTERVAL 14 DAY
-- dw3yj_tj
SELECT a.UniqueID,a.GzRq,a.YjFlDm,a.YjFl,a.YjKs,a.ExamType,a.TjLb,a.KdRc,a.Kd_Jf_Rc,a.Kd_Wc_Rc,a.Kd_JfYc_Rc,a.Kd_ExamYc_Rc,a.AVG_KdSh_Sc,a.Time1_Wc_Rate,a.Time2_Wc_Rate,a.Time3_Wc_Rate,a.Time4_Wc_Rate,a.Time5_Wc_Rate
,a.Time6_Wc_Rate,a.Yy_Gt_Rc,a.ZdYy_Xm_Cnt
,c.DjRc,c.Dj_Wjc_Rc
,d.JcRc,d.JcRs,d.Jc_Wwc_Rc,d.Avg_Dj_Jc_Sc,d.Dj_Jc_Rc,d.Dj_Jc_Rc1,d.Dj_Jc_Rc2,d.XmJe,d.Avg_XmJe
,e.WcRc,e.Avg_Jc_Sh_Sc,e.Avg_Bg_Sh_Sc,
a.Time1_Wc_Num,
a.Time2_Wc_Num,
a.Time3_Wc_Num,
a.Time4_Wc_Num,
a.Time5_Wc_Num,
a.Time6_Wc_Num,
a.Time_Wc_Den
FROM dw2yj_kd_tj a
LEFT JOIN dw2yj_dj_tj c ON a.GzRq=c.GzRq AND a.YjFlDm=c.YjFlDm AND a.YjKs=c.YjKs AND a.ExamType=c.ExamType AND a.TjLb=c.TjLb
LEFT JOIN dw2yj_exam_tj d ON a.GzRq=d.GzRq AND a.YjFlDm=d.YjFlDm AND a.YjKs=d.YjKs AND a.ExamType=d.ExamType AND a.TjLb=d.TjLb
LEFT JOIN dw2yj_bg_tj e ON a.GzRq=e.GzRq AND a.YjFlDm=e.YjFlDm AND a.YjKs=e.YjKs AND a.ExamType=e.ExamType AND a.TjLb=e.TjLb
WHERE a.GzRq>=CURRENT_DATE -INTERVAL 14 DAY AND a.YjFlDm='01'
UNION ALL
SELECT a.UniqueID,a.GzRq,a.YjFlDm,a.YjFl,a.YjKs,a.ExamType,a.TjLb,a.KdRc,a.Kd_Jf_Rc,a.Kd_Wc_Rc,a.Kd_JfYc_Rc,a.Kd_ExamYc_Rc,a.AVG_KdSh_Sc,a.Time1_Wc_Rate,a.Time2_Wc_Rate,a.Time3_Wc_Rate,a.Time4_Wc_Rate,a.Time5_Wc_Rate
,a.Time6_Wc_Rate,a.Yy_Gt_Rc,a.ZdYy_Xm_Cnt
,c.DjRc,c.Dj_Wjc_Rc
,d.JcRc,d.JcRs,d.Jc_Wwc_Rc,d.Avg_Dj_Jc_Sc,d.Dj_Jc_Rc,d.Dj_Jc_Rc1,d.Dj_Jc_Rc2,d.XmJe,d.Avg_XmJe
,e.WcRc,e.Avg_Jc_Sh_Sc,e.Avg_Bg_Sh_Sc,
a.Time1_Wc_Num,
a.Time2_Wc_Num,
a.Time3_Wc_Num,
a.Time4_Wc_Num,
a.Time5_Wc_Num,
a.Time6_Wc_Num,
a.Time_Wc_Den
FROM dw2yj_kd_tj a
LEFT JOIN dw2yj_dj_tj c ON a.GzRq=c.GzRq AND a.YjFlDm=c.YjFlDm AND a.YjKs=c.YjKs AND a.ExamType=c.ExamType
LEFT JOIN dw2yj_exam_tj d ON a.GzRq=d.GzRq AND a.YjFlDm=d.YjFlDm AND a.YjKs=d.YjKs AND a.ExamType=d.ExamType
LEFT JOIN dw2yj_bg_tj e ON a.GzRq=e.GzRq AND a.YjFlDm=e.YjFlDm AND a.YjKs=e.YjKs AND a.ExamType=e.ExamType
WHERE a.GzRq>=CURRENT_DATE -INTERVAL 14 DAY AND a.YjFlDm='02'
dm层显示的是开单人群效益分析数据,是日维度的,我现在需要周维度的dm层,也是从dw层抽取,请你给我建表语句和查询语句