排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-08-13 得物面试真题（5）每月iPhone用户和非iPhone用户  
SELECT 
    substr(purchase_time, 1,7) AS mon,
    CASE 
        WHEN product_type = 'iPhone' THEN 'iPhone'
        ELSE 'Not iPhone'
    END AS category,
    COUNT(DISTINCT user_id) AS user_count 
FROM apple_pchs_rcd
GROUP BY mon, category
ORDER BY mon, category;
2025-08-13 不经过第二象限的所有函数  
select 
    * 
from
    numbers_for_fun
where
    (a=0 and b>=0 and c <=0)
    or (a<0 and 
       (
           (b>=0 and c<=0)
       or (b<0 and c<=(b*b/4/a))
       )
       )
2025-08-13 北京有雪的日子  
select dt,tmp_h,tmp_l,con
from weather_rcd_china 
where con like '%雪%' and city ='beijing'
2025-08-13 北京有雪的日子  
select dt,tmp_h,tmp_l,con
from weather_rcd_china 
where con like '%雪%' and city -'beijing'
2025-08-13 北京有雪的日子  
select dt,tmp_h,tmp_l,con
from weather_rcd_china 
where con like '%雪%'
2025-08-11 基于共同兴趣爱好的餐厅推荐（4）-好基友（2）  
select t1.cust_uid,t2.cust_uid from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.cust_uid!=t2.cust_uid and t1.mch_nm=t2.mch_nm
where t1.cust_uid='mt10000' and t1.mch_nm in ('庄家界(千灯店)','黄记烘培宫廷桃酥王')
group by t1.cust_uid,t2.cust_uid order by t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（4）-好基友（2）  
select t1.cust_uid,t2.cust_uid from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.cust_uid=t2.cust_uid and t1.mch_nm=t2.mch_nm
where t1.cust_uid='mt10000' and t2.mch_nm in ('庄家界(千灯店)','黄记烘培宫廷桃酥王')
group by t1.cust_uid,t2.cust_uid order by t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（4）-好基友（2）  
select t1.cust_uid,t2.cust_uid from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.cust_uid=t2.cust_uid and t1.mch_nm=t2.mch_nm
where t1.cust_uid='mt10000' and t2.mch_nm in ('庄家界(千灯店)','黄记烘培宫廷桃酥王')
2025-08-11 基于共同兴趣爱好的餐厅推荐（3）-好基友（1）  
select 
t1.cust_uid,
t2.cust_uid,
t1.mch_nm
from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.mch_nm=t2.mch_nm and t1.cust_uid!=t2.cust_uid
where t1.mch_nm='兰州李晓明拉面馆' and t1.cust_uid='MT10000'
group byt1.cust_uid,
t2.cust_uid,
t1.mch_nm
order by t1.cust_uid,t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（3）-好基友（1）  
select 
t1.cust_uid,
t2.cust_uid,
t1.mch_nm
from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.mch_nm=t2.mch_nm and t1.cust_uid!=t2.cust_uid
where t1.mch_nm='兰州李晓明拉面馆' and t2.mch_nm='兰州李晓明拉面馆'
group byt1.cust_uid,
t2.cust_uid,
t1.mch_nm
order by t1.cust_uid,t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（3）-好基友（1）  
select 
t1.cust_uid,
t2.cust_uid,
t1.mch_nm
from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.mch_nm=t2.mch_nm and t1.cust_uid!=t2.cust_uid
where t1.mch_nm='兰州李晓明拉面馆'
group byt1.cust_uid,
t2.cust_uid,
t1.mch_nm
order by t1.cust_uid,t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（3）-好基友（1）  
select 
t1.cust_uid,
t2.cust_uid,
t1.mch_nm
from mt_trx_rcd1 t1
left join mt_trx_rcd1 t2 on t1.mch_nm=t2.mch_nm and t1.cust_uid!=t2.cust_uid
where t1.mch_nm='兰州李晓明拉面馆'
order by t1.cust_uid,t2.cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（2）-还有谁吃过  
select cust_uid, mch_nm from mt_trx_rcd1 
where mch_nm='兰州李晓明拉面馆'
 group by cust_uid,mch_nm
 order by cust_uid
2025-08-11 基于共同兴趣爱好的餐厅推荐（1）-我吃过啥  
select cust_uid, mch_nm from mt_trx_rcd1 
where cust_uid='MT10000'
group by cust_uid,mch_nm
 order by mch_nm asc
2025-08-11 基于共同兴趣爱好的餐厅推荐（1）-我吃过啥  
select cust_uid,mch_nm from mt_trx_rcd1 
where cust_uid='MT10000'
 order by mch_nm asc
2025-08-11 基于共同兴趣爱好的餐厅推荐（1）-我吃过啥  
select cust_uid,mch_nm from mt_trx_rcd1 
where cust_uid='MT10000'
2025-08-11 查询所有起点或终点为“海底捞西丽店”的行程记录  
select * from didi_sht_rcd 
where 
 start_loc='海底捞西丽店' or end_loc='海底捞西丽店'
2025-08-11 经过3个象限的一元一次函数  
select 
    * 
from
    numbers_for_fun
where
    a = 0 and b<>0 and c<>0
order by 1
2025-08-11 一元一次函数形成的三角形面积  
select * from numbers_for_fun 
where a=0 and b!=0 and abs(c*c/b)/2>=5
2025-08-11 一元一次函数形成的等腰三角形  
select 
    * 
from 
    numbers_for_fun
where 
    a=0 and b in (1,-1) and c!=0
order by 
    id