小宇啊

分类

/ 注册

全部文章（共111篇）

题解 | 2021年国庆在北京接单3次及以上的司机统计信息

select t.city, round(avg(t.order_num),3) as avg_order_num, round(avg(t.fare_sum),3) as avg_income from (select tgcr.city, ...

2025-04-21

0 50

题解 | 某乎问答高质量的回答中用户属于各级别的数量

select case when ut.author_level in (1,2) then '1-2级' when ut.author_level in (3,4) then '3-4级' else '5-6级' end as level_cut, ...

2025-04-21

0 51

题解 | 筛选限定昵称成就值活跃日期的用户

select distinct er.uid, ui.nick_name, ui.achievement from exam_record er left join practice_record pr on er.uid = ...

2025-04-14

0 42

题解 | 试卷完成数同比2020年的增长率及排名变化

WITH finish_2020 as ( select '2020' as start_year, ei.tag, count(er.submit_time) as exam_cnt f...

2025-04-14

0 30

题解 | 多报名表的运动项目人数统计

import pandas as pd df_items = pd.read_csv('items.csv') df_signup = pd.read_csv('signup.csv') df_signup1 = pd.read_csv('signup1.csv') merged_signup...

2025-04-08

0 65

题解 | 商品id数据清洗统计

select REGEXP_SUBSTR(order_id,'p[0-9]+') as product_id, count(REGEXP_SUBSTR(order_id,'p[0-9]+')) as cnt from order_log group by 1 ord...

2025-04-08

0 39

题解 | 每个顾客最近一次下单的订单信息

select t.order_id, c.customer_name, t.order_date from (select customer_id, order_id, order_date, row_n...

2025-04-08

0 39

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

select distinct t1.department, t1.average_actual_salary, ifnull(t2.average_actual_salary_male,0.00) as average_actual_sala...

2025-04-08

0 45

题解 | 统计用户从访问到下单的转化率

select date(ot.order_time) as date, concat(round(count(distinct ot.user_id) / count(distinct vt.user_id) * 100,1),'%') as cr from order_tb...

2025-03-21

0 41

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

select ot.user_id, count(distinct vt.visit_time) as visit_nums from order_tb ot left join visit_tb vt on ot.user_id = vt.user_id and ...

2025-03-21

0 42