排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-10-16 美狗计  
select 
replace(song_name,'人','狗')
from song_info 
where song_name like'%人%'
2025-10-16 美狗计  
select 
replace(singer_name,'人','狗')
from singer_info
2025-10-16 名字中字母e左起小于等于3位的歌手  
select 
singer_name,
case when locate('e',singer_name) in (1,2,3) then 1 else 0 end 
from singer_info
2025-10-16 按歌手名字字符长度统计歌手个数  
select 
length(singer_name),
count(singer_id)
from singer_info 
group by length(singer_name)
2025-09-18 人均消费金额定档标签  
select
mch_nm,
avg_amt,
case 
when avg_amt<100 then '低档'
when avg_amt between 100 and 300 then '中档'
when avg_amt>=300 then '高档'
end as type
from
(select 
mch_nm,
round(sum(trx_amt)/count(distinct cust_uid),4) as avg_amt
from mt_trx_rcd1 
group by mch_nm
 )t1
order by 2
2025-09-18 人均消费金额定档标签  
select
mch_nm,
avg_amt,
case 
when avg_amt<100 then '低档'
when avg_amt between 100 and 300 then '中档'
when avg_amt>=300 then '高档'
end as type
from
(select 
mch_nm,
round(sum(trx_amt)/count(1),4) as avg_amt
from mt_trx_rcd1 
group by mch_nm
 )t1
order by 2
2025-09-18 人均消费金额定档标签  
select
mch_nm,
avg_amt,
case 
when avg_amt<100 then '低档'
when avg_amt between 100 and 300 then '中档'
when avg_amt>=300 then '高档'
end as type
from
(select 
mch_nm,
round(sum(trx_amt)/count(1),4) as avg_amt
from mt_trx_rcd1 
group by mch_nm
 )t1
2025-09-18 人均消费金额定档标签  
select
mch_nm,
avg_amt,
case 
when avg_amt<100 then '低档'
when avg_amt between 100 and 300 then '中档'
when avg_amt>300 then '高档'
end as type
from
(select 
mch_nm,
round(sum(trx_amt)/count(1),4) as avg_amt
from mt_trx_rcd1 
group by mch_nm
 )t1
2025-09-18 人均消费金额定档标签  
select
mch_nm,
avg_amt,
case 
when avg_amt<100 then '低档'
when avg_amt between 100 and 300 then '中档'
when avg_amt>300 then '高档'
end as type
from
(select 
mch_nm,
round(sum(trx_amt)/count(1),2) as avg_amt
from mt_trx_rcd1 
group by mch_nm
 )t1
2025-09-18 人均消费金额定档标签  
select 
mch_nm,
sum(trx_amt)/count(1)
from mt_trx_rcd1 
group by mch_nm
2025-09-18 餐饮类别丰富度标签  
select
cust_uid,
case when cnt>=7 then 1 else 0 end as type
from(
select 
cust_uid,
count(distinct mch_typ2) as cnt
from mt_trx_rcd1 
group by cust_uid
)t1
2025-09-18 每日新增用户  
select 
first_login_date dt,
count(distinct usr_id) cnt
from
(
select 
usr_id,
min(date(login_time)) as first_login_date
from user_login_log 
group by usr_id
having first_login_date between '2024-09-01' and '2024-09-30'
) t1
group by first_login_date
order by 1
2025-09-18 每日新增用户  
select 
first_login_date,
count(distinct usr_id)
from
(
select 
usr_id,
min(date(login_time)) as first_login_date
from user_login_log 
group by usr_id
having first_login_date between '2024-09-10' and '2024-09-30'
) t1
group by first_login_date
order by 1
2025-09-18 每日新增用户  
select 
first_login_date,
count(distinct usr_id)
from
(
select 
usr_id,
min(date(login_time)) as first_login_date
from user_login_log 
group by usr_id
having first_login_date between '2024-09-10' and '2024-09-30'
) t1
group by first_login_date
2025-09-13 哔哩哔哩面试真题（1）按日分摊会员收入  
select
sum(case when datediff(begin_date,'2020-11-20')<= dur_time then daily_pay else 0 end)
from(
select
user_id uid,
begin_date,
datediff(end_date,begin_date) as dur_time,
pay_amount/datediff(end_date,begin_date) as daily_pay
from bilibili_m1
) t1
2025-09-13 统计字符长度  
select 
singer_name,
char_length(singer_name)
from singer_info
2025-09-05 德州扑克起手牌- 手对  
select * from hand_permutations where left(card1,1)=left(card2,1)
2025-09-05 德州扑克起手牌- A花  
select * from hand_permutations 
where (left(card1,1)='A' or left(card2,1)='A') and right(card1,1)=right(card2,1)
2025-09-05 德州扑克起手牌- A花  
select * from hand_permutations 
where left(card1,1)='A' or left(card2,1)='A'
2025-09-05 歌手名字大写  
select upper(singer_name) 
from singer_info