Kylin实例Cube实验

查询每周销售记录的数量：

SELECT COUNT(*),B.WEEK_BEG_DT FROM KYLIN_SALES AS A INNER JOIN KYLIN_CAL_DT AS B ON A.PART_DT=B.CAL_DT GROUP BY B.WEEK_BEG_DT ORDER BY B.WEEK_BEG_DT

查询每周的销售记录总数、价格均值、总价：

SELECT COUNT(*) AS 数量,AVG(A.PRICE) AS 价格均值,SUM(A.PRICE) AS 总价, B.WEEK_BEG_DT  FROM KYLIN_SALES AS A INNER JOIN KYLIN_CAL_DT AS B ON A.PART_DT=B.CAL_DT GROUP BY B.WEEK_BEG_DT ORDER BY B.WEEK_BEG_DT LIMIT 200