在思考的六边形战士很想去旅行

分类

/ 注册

全部文章（共90篇）

题解 | 发送offer

offer_list = ["Allen", "Tom"] print( f"{offer_list[0]}, you have passed our interview and will soon become a member of ou...

2025-09-18

1 27

题解 | 格式化输出（二）

name = input() print(name.lower(),name.upper(),name.title(),sep=('\n'))

2025-09-18

1 20

题解 | 为整数增加小数点

int_input = int(input()) print(float(int_input),type(float(int_input)),sep=('\n'))

2025-09-18

0 21

题解 | 牛牛的小数输出

float_input = float(input()) print(f"{float_input:.2f}") # 或者： # print("{:.2f}".format(float_input)) # 或者： # print('%.2f'%float_in...

2025-09-18

1 18

题解 | 读入整数数字

int_input = int(input()) print(int_input,type(int_input),sep=("\n"))

2025-09-18

0 24

题解 | 被重复观看次数最多的3个视频

with s1 as ( select uid, cid, count(*) as pv_per_user from play_record_tb prt group by cid, uid having pv_per_user > 1 ), s2 as ( s...

2025-09-17

1 24

题解 | 被重复观看次数最多的3个视频

with s1 as ( select uid, cid, count(*) as pv_per_user from play_record_tb prt group by cid, uid having pv_per_user > 1 ), s2 as ( s...

2025-09-17

1 18

题解 | 被重复观看次数最多的3个视频

with s1 as ( select uid, cid, count(*) as pv_per_user from play_record_tb prt group by cid, uid having pv_per_user > 1 ), s2 as ( s...

2025-09-17

1 21

题解 | 查找所有已经分配部门的员工的last_name和first_name以及dept_no

select e.last_name, e.first_name, d.dept_no from employees e left join dept_emp d on e.emp_no = d.emp_no where d.dept_no is not nu...

2025-08-05

1 38

题解 | 查找当前薪水详情以及部门编号dept_no

# 题目应当说清楚一点，优先以emp_no排序 select dm.emp_no, s.salary, s.from_date, dm.to_date, dm.dept_no from dept_manager dm left join salarie...

2025-08-05

1 37