全站第 22/1230 名
解决了 76/334 题
中等: 3/75
入门: 48/77
困难: 1/29
简单: 20/114
草履虫: 4/39
过去1年一共提交 113 次
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月10天提交;③里程碑:解决1/2/5/10/20/50/100/200题;④每周打卡挑战:完成每周5题,每年1月1日清零。




















收藏
收藏日期 | 题目名称 | 解决状态 |
---|---|---|
没有收藏的题目。 |
评论笔记
评论日期 | 题目名称 | 评论内容 | 站长评论 |
---|---|---|---|
没有评论过的题目。 |
提交记录
提交日期 | 题目名称 | 提交代码 |
---|---|---|
2025-04-11 | 特定渠道的中档单价用户 |
select * from apple_pchs_rcd where product_price>= 3000 and payment_method='Apple Pay' and order_channel='官网' order by order_id; |
2025-04-11 | 特定渠道的中档单价用户 |
select * from apple_pchs_rcd where product_price>=3000 and payment_method='Apple Pay' order by order_id; |
2025-04-11 | 找出所有港台歌手 |
select * from singer_info where type2='港台' order by singer_id; |
2025-04-11 | 找出所有港台乐队 |
select * from singer_info where type2='港台' and type3='乐队' order by singer_id; |
2025-04-11 | 特定歌曲的播放记录 |
select * from listen_rcd where (date(start_time) between '2023-12-10' and '2023-12-31') and song_id='13' order by start_time; |
2025-04-11 | 海王发红包 |
select snd_usr_id from tx_red_pkt_rcd where pkt_amt in (200,520) group by snd_usr_id having count(pkt_amt)>=5 order by snd_usr_id; |
2025-04-11 | 接收红包金额绿茶榜 |
select rcv_usr_id,sum(pkt_amt) as sum_trx_amt from tx_red_pkt_rcd where year(rcv_datetime) != 1900 group by rcv_usr_id order by sum_trx_amt desc limit 10; |
2025-04-11 | 红包金额土豪榜 |
select snd_usr_id,sum(pkt_amt) as sum_trx_amt from tx_red_pkt_rcd group by snd_usr_id order by sum_trx_amtdesc limit 10; |
2025-04-11 | 总分超过300分的学生 |
select student_id from subject_score where chinese+math+english>=300 order by student_id; |
2025-04-11 | 渣男腰子可真行,端午中秋干不停 |
select * from cmb_usr_trx_rcd where ((date(trx_time) between '2024-06-08' and '2024-06-10') or (date(trx_time) between '2024-09-15' and '2024-09-17')) and usr_id='5201314520' order by trx_time; |
2025-04-11 | 渣男腰子可真行,端午中秋干不停 |
select * from cmb_usr_trx_rcd where (date(trx_time) between '2024-06-08' and '2024-06-10') or (date(trx_time) between '2024-09-15' and '2024-09-17') and usr_id='5201314520' order by trx_time; |
2025-04-11 | 统计每个用户使用过的不同车型数量 |
select cust_uid, count(distinct car_cls) as unique_car_classes from didi_sht_rcd group by cust_uid order by unique_car_classes desc; |
2025-04-11 | 按照车类统计行程次数 |
select car_cls, count(start_tm) as trip_count from didi_sht_rcd group by car_cls order by trip_count desc; |
2025-04-11 | 查询所有起点或终点为“海底捞西丽店”的行程记录 |
select * from didi_sht_rcd where start_loc='海底捞西丽店' or end_loc='海底捞西丽店' order by start_tm; |
2025-04-11 | 通勤、午休、临睡个时间段活跃人数分布 |
select COUNT(DISTINCT case when (time(login_time ) between '07:30:00' and '09:30:00') or (time(login_time) between '18:30:00' and '20:30:00') then usr_id end) as commute, COUNT(DISTINCT case when (time(login_time) between '11:30:00' and '14:00:00') then usr_id end)as lunch_break, COUNT(DISTINCT case WHEN TIME(login_time) BETWEEN '22:30:00' AND '23:59:59' THEN usr_id WHEN TIME(login_time) BETWEEN '00:00:00' AND '01:00:00' THEN usr_idend ) as bedtime from user_login_log where login_time >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), '%Y-%m-01') AND login_time < DATE_FORMAT(CURDATE(), '%Y-%m-01'); |
2025-04-11 | 上月活跃用户数 |
SELECT COUNT(DISTINCT usr_id) AS active_users FROM user_login_log WHERE login_time >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), '%Y-%m-01 00:00:00') AND login_time < DATE_FORMAT(CURDATE(), '%Y-%m-01 00:00:00'); |
2025-04-11 | 国庆假期后第一天涨幅高于1%的股票 |
select ts_code,open_price,close_price from daily_stock_prices where trade_date='2023-10-09' and pct_change>1; |
2025-04-11 | 每年在深交所上市的银行有多少家 |
select year(list_date) as Y, count(distinct ts_code) as cnt from stock_info where right(ts_code,2)='SZ' and industry ='银行' group by Y order by Y ; |
2025-04-11 | 每年在深交所上市的银行有多少家 |
select year(list_date) as Y, count(distinct ts_code) as cnt from stock_info where right(ts_code,2)='SZ' and name like '%银行%' group by Y order by Y ; |
2025-04-11 | 每年在深交所上市的银行有多少家 |
select year(list_date) as Y, count(distinct name) as cnt from stock_info where right(ts_code,2)='SZ' and name like '%银行%' group by Y order by Y ; |