排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-04-08 统计每个用户使用过的不同车型数量  
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;
2026-04-08 查询所有终点是餐饮类地点的行程记录  
SELECT d.*
FROM didi_sht_rcd d
JOIN loc_nm_ctg l
ON d.end_loc = l.loc_nm
WHERE l.loc_ctg = '餐饮'
ORDER BY d.start_tm;
2026-04-08 按照车类统计行程次数  
SELECT car_cls,COUNT(car_cls) AS trip_count
FROM didi_sht_rcd
GROUP BY car_cls
ORDER BY trip_count DESC;
2026-04-08 查询所有起点或终点为“海底捞西丽店”的行程记录  
SELECT *
FROM didi_sht_rcd
WHERE start_loc = '海底捞西丽店' OR end_loc = '海底捞西丽店'
ORDER BY start_tm;
2026-04-05 不分类别的最火直播间  
SELECT ks_live_t1.live_id,ks_live_t2.live_nm,COUNT(enter_time) AS enter_cnt
FROM ks_live_t1
JOIN ks_live_t2
ON ks_live_t1.live_id = ks_live_t2.live_id
WHERE DATE(enter_time) = '2021-09-12' AND HOUR(enter_time) = 23
GROUP BY ks_live_t1.live_id,ks_live_t2.live_nm
ORDER BY enter_cnt DESC
LIMIT 5;
2026-04-05 绘制小时进入人数曲线  
SELECT LPAD(HOUR(enter_time),2,'0') AS hour_entered, COUNT(usr_id) AS enter_count
FROM ks_live_t1
GROUP BY hour_entered
ORDER BY hour_entered;
2026-04-05 绘制小时进入人数曲线  
SELECT HOUR(enter_time) AS hour_entered, COUNT(usr_id) AS enter_count
FROM ks_live_t1
GROUP BY hour_entered
ORDER BY hour_entered;
2026-04-05 曝光量最大的商品  
SELECT tb_prd_map.prd_id, tb_prd_map.prd_nm, SUM(if_snd) AS exposure_cnt
FROM tb_prd_map
JOIN tb_pg_act_rcd
ON tb_prd_map.prd_id = tb_pg_act_rcd.prd_id
GROUP BY tb_prd_map.prd_id,tb_prd_map.prd_nm
ORDER BY exposure_cnt DESC
LIMIT 1;
2026-04-05 输出特定日期上市的银行  
select * 
from stock_info
WHERE list_date between '2006-06-01' AND '2006-09-01' AND industry = '银行';
2026-04-05 21世纪上市的银行  
select * 
from stock_info
WHERE YEAR(list_date) >= 2000 AND industry = '银行'
ORDER BY list_date;
2026-04-05 21世纪上市的银行  
select * 
from stock_info
WHERE YEAR(list_date) >= 2000
ORDER BY list_date;
2026-04-05 输出地区为北京的所有银行  
SELECT *
FROM stock_info
WHERE area = '北京' AND industry = '银行'
ORDER BY list_date;
2026-04-05 国庆假期后第一天涨幅高于1%的股票  
select ts_code,open_price,close_price
from daily_stock_prices
WHERE pct_change > 1 AND trade_date = '2023-10-09';
2026-04-05 国庆假期后第一天涨幅高于1%的股票  
select ts_code,open_price,close_price
from daily_stock_prices
WHERE pct_change > 0.01 AND trade_date = '2023-10-09';
2026-04-05 国庆假期后第一天涨幅高于1%的股票  
select ts_code,open_price,close_price
from daily_stock_prices
WHERE pct_change > 0.01 AND trade_date > '2023-10-01';
2026-04-05 每年在深交所上市的银行有多少家  
SELECT YEAR(list_date) as y,COUNT(DISTINCT ts_code) AS cnt
FROM stock_info
WHERE industry = '银行' AND ts_code LIKE '%SZ%'
GROUP BY y
ORDER BY y;
2026-04-05 每年在深交所上市的银行有多少家  
SELECT YEAR(list_date) as y,COUNT(DISTINCT ts_code) AS cnt
FROM stock_info
WHERE industry = '银行' AND area = '深圳'
GROUP BY y
ORDER BY y;
2026-04-05 每年在深交所上市的银行有多少家  
SELECT YEAR(list_date) as y,COUNT(DISTINCT ts_code)
FROM stock_info
WHERE industry = '银行'
GROUP BY y
ORDER BY y;
2026-04-05 每年在深交所上市的银行有多少家  
SELECT YEAR(list_date) as y,COUNT(DISTINCT ts_code)
FROM stock_info
GROUP BY y
ORDER BY y;
2026-04-05 特定歌曲的播放记录  
SELECT *
FROM listen_rcd
WHERE song_id = 13 AND DATE(start_time) BETWEEN '2023-12-10' AND '2023-12-31'
ORDER BY start_time;