python之王

分类

/ 注册

全部文章（共38篇）

题解 | #工作日各时段叫车量、等待接单时间和调度时间#

select period, count(a.order_id) as get_car_num, round(avg(timestampdiff(second,event_time,order_time)/60), 1) as avg_wait_time, roun...

2024-01-24

0 238

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

with t as ( select date(order_time) as dt, order_id, mileage, start_time ...

2024-01-23

0 226

题解 | #每个城市中评分最高的司机信息#

select city, driver_id, avg_grade, avg_order_num, avg_mileage from ( select city, driver_id,...

2024-01-23

0 192

题解 | #某店铺的各商品毛利率及店铺整体毛利率#

# 题目：计算2021年10月以来店铺901中商品毛利率大于24.9%的商品信息及店铺整体毛利率。 # 要求：结果先输出店铺毛利率，再按商品ID升序输出各商品毛利率，均保留1位小数。 # 1、计算901店铺整体毛利率 # 店铺毛利率=(1-总进价成本/总销售收入)*100% with t as ( ...

2024-01-15

0 419

题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#

select date, user_id, pass_count from ( select date, user_id, pass_count, dense_ra...

2023-12-26

0 172

题解 | #分群并计算群体人数#

select age_group, count(age_group) as user_count from( select *, case when age<20 then '20以下' ...

2023-12-26

0 219

题解 | 查询职位发布时间在2021年后或职位城市为上海

select job_id, boss_id, company_id from ( select job_id, boss_id, company_id, ...

2023-12-25

0 309

题解 | 查询2022年以来刷题用户user_id和毕业院校

select a.user_id, university from questions_pass_record a left join user_info b on a.user_id = b.user_id where date>='202...

2023-12-25

0 200

题解 | #查询2022年毕业用户的刷题记录#

select user_id, question_type, device, pass_count, date from questions_pass_record where user_id in(select distinct(user...

2023-12-22

0 189

题解 | #查询薪资信息不为空的职位投递记录#

select * from deliver_record_detail where min_salary is not null or max_salary is not null

2023-12-22

0 177