blob: 021caf4bbb6cbd2e1663ce9e4d4e562340b91bc0 [file] [log] [blame]
select lstg_format_name, cal_dt,
sum(price) as GMV,
count(1) as TRANS_CNT,
count(distinct seller_id) as DIST_SELLER
from test_kylin_fact
group by lstg_format_name, cal_dt