向日葵的骄傲，你知道吗

分类

/ 注册

全部文章（共20篇）

题解 | 营销带货销量分析

半成品，哈哈，期待大佬好好看看着题咋回事

2025-10-02

0 15

题解 | 寻找设计师

select b.物料类型,count(distinct a.物料号) as 面料数 from 物料清单表 as a left join 面料信息表 as b on a.物料号=b.物料号 where a.设计师=01 group by b.物料类型 order by 面料数 desc;

2025-10-01

0 13

题解 | 库存分析

select a.商品号,a.尺码,round(sum(b.库存数)/sum(a.近7天销量),4) as 存销比 from 订单表 as a left join 库存表 as b on a.商品号=b.商品号 and a.尺码=b.尺码 group by a.商品号,a.尺码 order by a...

2025-10-01

0 11

题解 | 行列互换

select 年, sum(if(分类='m1',值,0.0)) as 'm1', sum(if(分类='m2',值,0.0)) as 'm2', sum(if(分类='m3',值,0.0)) as 'm3', sum(if(分类='m4',值,0.0)) as 'm4' from (select ...

2025-10-01

0 11

题解 | 快递量区间分布

select 单量,count(*) as 客户数 from(select *,case when 单总<=5 then '0-5' when 单总<=10 then '6-10' when 单总<=20 then '11-20' else '20以上' end as 单量 fro...

2025-09-30

0 18

题解 | 店铺订单分析

select 订单数区间,count(*) as 人数 from (select *,case when 订单数<=2 then '0-2' when 订单数<=5 then '3-5' else'5单以上' end as 订单数区间 from 订单表) as new1 group b...

2025-09-30

0 11

题解 | 学生成绩分析

select 等级,count(*) as 学生人数 from (select *,case when 分数<60 then '不及格' when 分数<=70 then '及格' when 分数<=85 then '良好' when 分数<=100 then '优秀'...

2025-09-30

0 12

题解 | 查找成绩排名第二的学生成绩

select ifnull( (select max(distinct 成绩) from 成绩表 where 课程="语文" and 成绩<(select max(成绩) from 成绩表 where 课程="语文")), ...

2025-09-30

0 15

题解 | 购买行为分析3

select 顾客ID from 销售订单表 group by 顾客ID having sum(产品='ProductA')>0 and sum(产品='ProductB')>0 and sum(产品='ProductC')=0;

2025-09-30

1 12

题解 | 查找重复数据

select 姓名 from 学生表 group by 姓名 having count(*)>=2;

2025-09-29

0 11