【sql】 按日期分组统计

select
dt,
count(distinct item_id) as spu_qtty
from
app.table1
where
dt >= '2019-03-07'
group by
dt