排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-01-08 大于J小于K的手牌 
select 
* 
from 
hand_permutations
where 
( card1 > 'J'
and card1 < 'K')
and
( card2 > 'J'
and card2 < 'K')
order by id
2025-01-08 大于J小于K的手牌 
select 
* 
from 
hand_permutations
where 
left(card1,1) = 'Q'
and left(card2,1) = 'Q'
order by id
2025-01-08 大于J小于K的手牌 
select 
* 
from 
hand_permutations
where 
left(card1,1) in ('J','Q','K')
and left(card2,1) in ('J','Q','K')
order by id
2025-01-08 语文数学英语至少1门超过100分的同学 
select 
*
from 
subject_score
where
chinese>100 
or math>100
or english>100
order by 
chinese
2025-01-08 性别已知的听歌用户 
select 
*
from 
qqmusic_user_info
where 
gender in('m','f')
and year(birth_date)='1980'
2025-01-08 2000年以前出生的男歌手 
select 
*
from 
singer_info
where 
birth_date < '2000-01-01'
and gender = 'm'
2025-01-08 21世纪上市的银行 
select 
*
from 
stock_info
where 
industry = '银行'
and left(list_date,2)='20'
order by 
list_date
2025-01-08 条件过滤(1)异地男友有异常,数分闺蜜来帮忙 
select
*
from 
cmb_usr_trx_rcd
where 
usr_id = '5201314520'
and (date(trx_time)>='2024-09-01'
 and date(trx_time)<='2024-09-30')
order by
trx_time
2025-01-08 德州扑克起手牌- 手对 
select 
*
from 
hand_permutations
where
left(card1,1)=left(card2,1)
2025-01-07 德州扑克起手牌- A花 
select
*
from 
hand_permutations
where 
(left(card1,1)='A'
or left(card2,1)='A')
and (right(card1,1)=right(card2,1))
2025-01-07 德州扑克起手牌- A花 
select
*
from 
hand_permutations
where 
left(card1,1)='A'
or left(card2,1)='A'
and right(card1,1)=right(card2,1)
2025-01-07 德州扑克起手牌-最强起手牌KK+ 
select 
*
from 
hand_permutations
where
(left(card1,1)='A' and left(card2,1)='A')
or (left(card1,1)='K' and left(card2,1)='K')
or (left(card1,1)='A' and left(card2,1)='K')
or (left(card1,1)='K' and left(card2,1)='A')
2025-01-07 抖音面试真题(1)T+1日留存率 
with data1 as (
select distinct 
usr_id, 
date(login_time) as login_date
from 
user_login_log
where 
datediff(current_date,date(login_time))<=30
),
data2 as (
select 
t1.usr_id,
t1.login_date as T_date,
t2.login_date as T_1_date
from 
data1 as t1 
left join 
data1 as t2
on 
t1.usr_id = t2.usr_id 
and datediff(t1.login_date,t2.login_date)=-1
)
select 
T_date as login_date, 
concat(round(avg(T_1_date is not null)*100,2),'%') as T1_retention_rate
from 
data2
group by 
T_date
order by 
T_date
2025-01-07 抖音面试真题(1)T+1日留存率 
with data1 as (
select distinct 
usr_id, 
date(login_time) as login_date
from 
user_login_log
where 
datediff('2024-10-21',date(login_time))<=30
),
data2 as (
select 
t1.usr_id,
t1.login_date as T_date,
t2.login_date as T_1_date
from 
data1 as t1 
left join 
data1 as t2
on 
t1.usr_id = t2.usr_id 
and datediff(t1.login_date,t2.login_date)=-1
)
select 
T_date as login_date, 
concat(round(avg(T_1_date is not null)*100,2),'%') as T1_retention_rate
from 
data2
group by 
T_date
order by 
T_date
2025-01-07 抖音面试真题(1)T+1日留存率 
with data1 as (
select distinct 
usr_id, 
date(login_time) as login_date
from 
user_login_log
where 
datediff('2024-10-20',date(login_time))<=30
),
data2 as (
select 
t1.usr_id,
t1.login_date as T_date,
t2.login_date as T_1_date
from 
data1 as t1 
left join 
data1 as t2
on 
t1.usr_id = t2.usr_id 
and datediff(t1.login_date,t2.login_date)=-1
)
select 
T_date as login_date, 
concat(round(avg(T_1_date is not null)*100,2),'%') as T1_retention_rate
from 
data2
group by 
T_date
order by 
T_date
2025-01-07 抖音面试真题(1)T+1日留存率 
with data1 as (
select distinct 
usr_id, 
date(login_time) as login_date
from 
user_login_log
where 
datediff(current_date,date(login_time))<=30
),
data2 as (
select 
t1.usr_id,
t1.login_date as T_date,
t2.login_date as T_1_date
from 
data1 as t1 
left join 
data1 as t2
on 
t1.usr_id = t2.usr_id 
and datediff(t1.login_date,t2.login_date)=-1
)
select 
T_date as first_login_date, 
concat(round(avg(T_1_date is not null),2)*100,'%') as T1_retention_rate
from 
data2
group by 
T_date
order by 
T_date
2025-01-03 曝光量最大的商品 
with t1 as (
select tb_pg_act_rcd.prd_id,sum(if_snd) as exposure_cnt
from tb_pg_act_rcd 
group by tb_pg_act_rcd.prd_id
) 
select t2.prd_id,t2.prd_nm,t1.exposure_cnt
from tb_prd_map as t2
left join t1
on t2.prd_id = t1.prd_id
order by t1.exposure_cnt desc
limit 1
2025-01-03 曝光量最大的商品 
with t1 as (
select tb_pg_act_rcd.prd_id,sum(if_snd) as exposure_cnt
from tb_pg_act_rcd 
group by tb_pg_act_rcd.prd_id
) 
select t2.prd_id,t2.prd_nm,t1.exposure_cnt
from tb_prd_map as t2
left join t1
on t2.prd_id = t1.prd_id
order by t1.exposure_cnt desc
2025-01-03 曝光量最大的商品 
with t1 as (
select tb_pg_act_rcd.prd_id,sum(if_snd) as cnt
from tb_pg_act_rcd 
group by tb_pg_act_rcd.prd_id
) 
select t2.prd_id,t2.prd_nm,t1.cnt
from tb_prd_map as t2
left join t1
on t2.prd_id = t1.prd_id
order by t1.cnt desc