Sign in
apache
/
kylin
/
72138e235a307ac71061421d31b802969263e4ab
/
.
/
query
/
src
/
test
/
resources
/
query
/
sql_distinct
/
query00.sql
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