Hi Kylin Dev team,

I used a dataset called learn_kylin, the sample data of table kylin_sales looks 
like:

A problem came when I inputed sql query as: " select LSTG_FORMAT_NAME, 
avg(price) over(partition by LSTG_FORMAT_NAME) as price_level, max(price) 
over(partition by LSTG_FORMAT_NAME) as price_max, min(price) over(partition by 
LSTG_FORMAT_NAME) as price_min from kylin_sales" then replicated results 
returned. They look like:


How does this happen and if there is any way to solve it?
Thank you!

Luyuan(Adora)





Reply via email to