Owen433

分类

/ 注册

全部文章（共65篇）

题解 | #考试分数(五)#

SELECT t1.id, t1.job, t1.score, t1.medium FROM (SELECT *, RANK() OVER (PARTITION BY job ORDER BY score desc) as t...

2023-09-20

0 223

题解 | #姓名与学号#

my_dict_1 = {'name': 'Niuniu', 'Student ID': 1} my_dict_2 = {'name': 'Niumei', 'Student ID': 2} my_dict_3 = {'name': 'Niu Ke Le', 'Student ID': 3} dic...

2023-09-19

0 284

题解 | #牛客每个人最近的登录日期(五)#

select t2.date, case when sum(t2.first_login) = 0 then 0.000 else round(sum(case when ...

2023-09-19

0 214

题解 | #增加元组的长度#

old_tuple = tuple(range(1,6)) print(old_tuple) print(len(old_tuple)) new_tuple = old_tuple+tuple(range(6,11)) print(new_tuple) print(len(new_tuple))

2023-09-18

0 240

题解 | #名单中出现过的人#

my_list = ['Tom', 'Tony', 'Allen', 'Cydin', 'Lucy', 'Anna'] my_list = tuple(my_list) str1 = input() print(my_list) if str1 in my_list: print('Cong...

2023-09-18

0 270

题解 | #修改报名名单#

entry_form = tuple(('Niuniu','Niumei')) print(entry_form) try: entry_form[1] = 'Niukele' except: print('The entry form cannot be modified!')

2023-09-18

0 224

题解 | #运动会双人项目#

name1 = input() name2 = input() print((name1,name2))

2023-09-18

0 256

题解 | #获取每个部门中当前员工薪水最高的相关信息#

select t3.dept_no, t3.emp_no, t3.maxSalary from (select t1.dept_no, t1.emp_no, t2.salary, max(t2.sala...

2023-09-18

0 331

题解 | #牛客的课程订单分析(四)#

select t1.user_id, min(t1.date) first_buy_date, count(*) cnt from order_info t1 where t1.status = 'completed' and t1.produc...

2023-09-17

0 274

题解 | #考试分数(四)#

select job, case when (t1.rk +1) % 2 = 0 then round((t1.rk + 1)/2,0) else round(t1.rk/2,0)...

2023-09-16

0 328