舒舒南

分类

/ 注册

全部文章（共26篇）

题解 | 某宝店铺动销率与售罄率

select t1.style_id, round(100*sum(sales)/(sum(inventory)-sum(sales)),2) pin_rate, round(100*sum(gmv)/sum(tag_price*inventory),2) sellthrough_rate fro...

2025-10-19

0 5

题解 | 国庆期间近7日日均取消订单量

with per_day as ( select date(order_time) order_time, count(fare) finish, sum(case when start_time is null then 1 end) cancel from tb_get_car_order g...

2025-10-12

0 8

题解 | 店铺901国庆期间的7日动销率和滞销率

with f3 as ( select distinct date(event_time) date1 from tb_order_overall where date(e...

2025-09-18

0 20

题解 | 统计每个产品的销售情况

#先计算价格、总销售额、总销售量 with total as (select o.product_id,unit_price,sum(quantity*unit_price) total_sales,sum(quantity) as total_quantity from orders o lef...

2025-09-05

0 25

题解 | 贷款情况

with max_type as (--统计每个城市每种类型贷款的数量 select city, lat.loan_type_id, loan_type_name, row_num...

2025-09-02

0 20

题解 | 统计作答次数

select count(*) total_pv, count(score) complete_pv, (select count(distinct exam_id) from exam_record where score is not null) complete_exa...

2025-05-05

0 40

题解 | SQL类别高难度试卷得分的截断平均值

with sql_score as ( select tag, difficulty, score, row_number() over ( ord...

2025-05-05

0 50

题解 | 查询成绩

select count(*) from ( select count(*) from SC group by sId having ...

2025-03-23

0 53

题解 | 查询下订单用户访问次数？

select t1.user_id,count(*) visit_nums from (select distinct user_id,date_format(order_time,'%Y-%m-%d') order_time from order_tb)t1 join visit_tb t2 on...

2025-03-12

0 54

题解 | 统计每种性别的人数

select 'male',count(profile) from user_submit where profile like '%,male' union select 'female',count(profile) from user_submit where profile like '%f...

2025-03-11

0 70