排名
用户解题统计
过去一年提交了
勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月10天提交;③里程碑:解决1/2/5/10/20/50/100/200题;④每周打卡挑战:完成每周5题,每年1月1日清零。
收藏
| 收藏日期 | 题目名称 | 解决状态 |
|---|---|---|
| 没有收藏的题目。 | ||
评论笔记
| 评论日期 | 题目名称 | 评论内容 | 站长评论 |
|---|---|---|---|
| 没有评论过的题目。 | |||
提交记录
| 提交日期 | 题目名称 | 提交代码 |
|---|---|---|
| 2026-02-26 | 特定渠道的中档单价用户  |
select * from apple_pchs_rcd where product_price>=2999 and order_channel='官网' and payment_method='Apple Pay' order by order_id; |
| 2026-02-26 | 文科潜力股  |
select * from scores where exam_date='2024-06-30'and (subject='历史' or subject='政治' or subject='地理') and score>89 order by score desc,student_id,subject; |
| 2026-02-26 | 给英语成绩中上水平的学生拔尖  |
select * from scores where score between 100 and 110 and subject='英语' and exam_date='2024-06-30' order by score desc; |
| 2026-02-26 | 给英语成绩中上水平的学生拔尖  |
select * from scores where score between 100 and 110 and subject='英语' order by score desc; |
| 2026-02-26 | 找出三个班级的女生  |
select * from students where (class_code='C219'or class_code='C220' or class_code='C221') and gender='f' order by student_id; |
| 2026-02-26 | 大于J小于K的手牌  |
select * from hand_permutations where (card1>'J' and card1<'K')and (card2>'J' and card2<'K'); |
| 2026-02-26 | 2000年以前出生的男歌手  |
select * from singer_info where birth_date <'2000-01-01'and gender='m' |
| 2026-02-26 | 总分超过300分的学生  |
select student_id from subject_score where chinese+math+english>=300; |
| 2026-02-26 | 国庆假期后第一天涨幅高于1%的股票  |
select ts_code,open_price,close_price from daily_stock_prices where trade_date='2023-10-09' and pct_change>1; |
| 2026-02-26 | 德州扑克起手牌-最强起手牌KK+  |
select *from hand_permutations where(card1 like "A%" or card1 like "K%") and (card2 like "A%" or card2 like "k%") order by id; |