构造测试数据
本文用子查询的形式构造测试数据,朋友们也可以通过 CREATE_TABLE 进行构造测试数据。
-- 假设某店铺上个月卖出去了5款iPhone手机,以下是具体型号和销售数量
SELECT 'iPhone 1' AS type
,10 AS num
UNION
SELECT 'iPhone 2' AS type
,30 AS num
UNION
SELECT 'iPhone 3' AS type
,50 AS num
UNION
SELECT 'iPhone 4' AS type
,80 AS num
UNION
SELECT 'iPhone 5' AS type
,20 AS num
销售数据如下
case_when 划分区间
期望将销量划分为“小于等于30”、“小于等于50”和“大于50”三个区间