python之王
python之王
全部文章
分类
归档
标签
去牛客网
登录
/
注册
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
首页
上一页
1
2
3
4
下一页
末页