排名

用户解题统计

过去一年提交了

勋章 ①金银铜：在竞赛中获得第一二三名；②好习惯：自然月10天提交；③里程碑：解决1/2/5/10/20/50/100/200题；④每周打卡挑战：完成每周5题，每年1月1日清零。

收藏

收藏日期 题目名称 解决状态
没有收藏的题目。

评论笔记

评论日期 题目名称 评论内容 站长评论
没有评论过的题目。

提交记录

提交日期 题目名称 提交代码
2026-01-26 滴滴面试真题（1）-打车订单应答率  
SELECT 
    COUNT(order_id) AS total_orders,
    SUM(CASE WHEN grab_time != '1970-01-01 00:00:00' THEN 1 ELSE 0 END) AS answered_orders,
    CONCAT(ROUND((SUM(CASE WHEN grab_time != '1970-01-01 00:00:00' THEN 1 ELSE 0 END) * 1.0 / COUNT(order_id)) * 100, 2), '%') AS answer_rate
FROM 
    didi_order_rcd
WHERE 
    DATE(call_time) = '2021-05-03';
2026-01-26 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select * from cmb_usr_trx_rcd 
where usr_id = '5201314520'
and date(trx_time) between '2024-09-01' and '2024-09-30'
and hour(trx_time) between 1 and 5;
2026-01-26 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd
where date(trx_time) between '2024-09-01' and '2024-09-30'
and usr_id = '5201314520';
2026-01-26 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd
where date(trx_time) between '2024-09-01' and '2024-09-30';
2026-01-26 一线城市历年平均气温  
select year(dt) as Y
    ,cast(avg(case when city='beijing' then tmp_h else null end) as decimal(4,2)) as '北京'
    ,cast(avg(case when city='shanghai' then tmp_h else null end) as decimal(4,2)) as '上海'
    ,cast(avg(case when city='shenzhen' then tmp_h else null end) as decimal(4,2)) as'深圳'
    ,cast(avg(case when city='guangzhou' then tmp_h else null end) as decimal(4,2)) as '广州'
from
    weather_rcd_china
where 
    year(dt) between 2011 and 2022
group by 
    year(dt)