排名

用户解题统计

过去一年提交了

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

收藏

收藏日期 题目名称 解决状态
2025-03-30 抖音面试真题（1）T+1日留存率  已解决
2025-03-24 每年在深交所上市的银行有多少家  已解决

评论笔记

评论日期 题目名称 评论内容 站长评论
2025-03-30 不经过第二象限的所有函数  
输出示例是不是错了，我带入了一下全是过第二象限的
 
啥也没说

提交记录

提交日期 题目名称 提交代码
2025-03-31 绘制小时进入人数曲线  
SELECT lpad(hour_entered, 2, '0') as hour_entered, enter_count
FROM
(SELECT HOUR(enter_time) hour_entered, COUNT(HOUR(enter_time)) enter_count
FROM ks_live_t1 
GROUP BY HOUR(enter_time)
ORDER BY HOUR(enter_time)) AS S
ORDER BY hour_entered
2025-03-31 绘制小时进入人数曲线  
SELECT HOUR(enter_time) 
hour_entered, COUNT(HOUR(enter_time)) enter_count
FROM ks_live_t1 
GROUP BY HOUR(enter_time)
ORDER BY HOUR(enter_time)
2025-03-30 经过至少两个象限的一元一次函数  
SELECT * 
FROM numbers_for_fun
WHERE a=0 AND b!=0 
ORDER BY id
2025-03-30 经过至少两个象限的一元一次函数  
SELECT * 
FROM numbers_for_fun
WHERE a=0 AND b!=0 AND c=0
ORDER BY id
2025-03-30 经过3个象限的一元一次函数  
SELECT * 
FROM numbers_for_fun
WHERE a=0 AND b!=0 AND c!=0
ORDER BY id
2025-03-30 查询所有起点或终点为“海底捞西丽店”的行程记录  
SELECT *
FROM didi_sht_rcd 
WHERE start_loc = '海底捞西丽店' OR end_loc = '海底捞西丽店'
ORDER BY start_tm
2025-03-30 不经过第二象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
   (a<0 AND c<=0) OR 
 	(a=0 AND b>=0 AND c<=0)
2025-03-30 不经过第二象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
   (a<0 AND c<=0) OR 
 	(a=0 AND b>0 AND c<=0) OR 
(a=0 AND b=0 AND c<=0)
2025-03-30 不经过第二象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
   (a<0 AND c<=0) OR 
 	(a=0 AND b>0 AND c<=0) OR 
(a=0 AND b<0 AND c<=0) OR 
(a=0 AND b=0 AND c<=0)
2025-03-30 不经过第二象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
   (a<0 AND c<0) OR 
 	(a=0 AND b>0 AND c<0) OR 
(a=0 AND b<0 AND c<0) OR 
(a=0 AND b=0 AND c<0)
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND (c < 0 OR (b < 0 AND 4*a*c < b*b))) OR 
	(a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0) OR 
(a=0 AND b = 0 AND c < 0)
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND c<0) OR 
	(a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0) OR 
(a=0 AND b = 0 AND c < 0)
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND c<0) OR 
	((a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0 AND c>0)) OR 
(a=0 AND b = 0 AND c < 0)
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND c<0) OR 
	((a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0 AND c>0)) OR 
(b = 0 AND c < 0)
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND c<0) OR 
	((a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0 AND c>0))
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a < 0 OR (a>0 AND c<0) OR 
	((a=0 AND b > 0 AND c<0) OR
(a=0 AND b < 0 AND c>0))
order by id
2025-03-30 经过第四象限的所有函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a > 0 OR (a<0 AND c>0) OR 
	((a=0 AND b > 0 AND c>0) OR
(a=0 AND b < 0 AND c>0))
order by id
2025-03-30 与X轴有且只有一个交点的一元二次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    b*b - 4*a*c = 0 and a<>0
order by id
2025-03-30 开口向上且经过原点的一元二次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a>0 and c = 0
order by id
2025-03-30 开口向上的一元二次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a>0 
order by id