| select test_kylin_fact.lstg_format_name, test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV | |
| , count(*) as TRANS_CNT | |
| from test_kylin_fact | |
| inner JOIN test_cal_dt | |
| ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt | |
| where DATE '2013-02-10' <= test_cal_dt.week_beg_dt | |
| group by test_kylin_fact.lstg_format_name, test_cal_dt.week_beg_dt |