" varchar(50) ,
"level1" varchar(50)
);
2.3表字段注释
字段 注释
id 主键
name 商品名称
price 价格
level2 二级分类
level1...一级分类
2.4表数据
INSERT INTO "report2"("id", "name", "price", "level2", "level1") VALUES ('0015', '洗发露',...'36', '洗护', '日用品');
INSERT INTO "report2"("id", "name", "price", "level2", "level1") VALUES ('0008',...'香皂', '17.5', '洗护', '日用品');
INSERT INTO "report2"("id", "name", "price", "level2", "level1") VALUES (...order by level1,level2 asc) tu_rank,
count(1) over (partition by level1,level2) tu_count
from