学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #反转字符串#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # 反转字符串 # @param str string字符串 # @return string字符串 # class Solution: def solve(self , str: str) -&...

2024-11-21

0 64

题解 | #最小花费爬楼梯#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param cost int整型一维数组 # @return int整型 # class Solution: def minCostClimbingStairs(self , cost: Li...

2024-11-21

0 43

题解 | #斐波那契数列#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param n int整型 # @return int整型 # class Solution: def Fibonacci(self , n: int) -> int: ...

2024-11-21

0 76

题解 | #插入记录（一）#

insert into exam_record (id, uid, exam_id, start_time, submit_time, score) values (1,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90)...

2024-11-20

0 60

题解 | #判断其是否有过购买记录#

select customer_id, if(latest_place_order_date is null,0,1) as if_placed_order from customers_info;

2024-11-20

1 68

题解 | #查询职位发布时间在2021年后或职位城市为上海

select job_id, boss_id, company_id from job_info where job_city='上海' union select job_id, boss_id, company_id fro...

2024-11-20

0 168

题解 | #查询职位城市在北京或_id，结果不去重

select job_id, company_id from job_info where job_city='北京' union all select job_id, company_id from job_info where s...

2024-11-20

0 60

题解 | #查询每个公司查看过的投递用户数#

select job_info.company_id as company_id, count(deliver_record.resume_if_checked) as cnt from deliver_record join job_info on deliver_...

2024-11-20

0 84

题解 | #查询被投递过的职位信息#

select job_info.company_id as company_id, count(deliver_record.resume_if_checked) as cnt from deliver_record join job_info on job_info...

2024-11-20

0 46

题解 | #统计每天刷题数超过5的user_id以及刷题数#

select date, user_id, sum(pass_count) as total_pass_count from questions_pass_record_detail group by user_id,date having sum(pass_...

2024-11-20

0 97