牛客804125561号

分类

/ 注册

全部文章（共7篇）

查找employees表员工信息

SELECT * FROM employees WHERE CAST(emp_no AS UNSIGNED) % 2 != 0 AND last_name != 'Mary' order by hire_date desc

2024-10-05

0 59

题解 | #生成连续数字#

num = int(input()) ls = [] for i in range(0,num): ls.append((i+1)*2) print(ls)

2024-09-29

0 57

题解 | #每个商品的销售总额#

select name as product_name, sum(quantity) as total_sales, rank() over (partition by category order by sum(quantity) desc) as category_rank from produ...

2024-09-26

1 82

题解 | #查询连续入住多晚的客户信息？#

select user_id, c.room_id, room_type, datediff(checkout_time, checkin_time) as days from checkin_tb c join guestroom_tb j on c.room_id = j.room_id whe...

2024-09-25

0 82

题解 | #牛牛的朋友们#

x,y = map(int, input().split()) def daycount(x, y): print(x+y, x-y) print((x+y)*(x-y)) daycount(x,y)

2024-09-24

0 74

题解 | #浙大不同难度题目的正确率#

select difficult_level, sum(case when result = 'right' then 1 else 0 end) / count(qpd.question_id) as correct_rate from question_practice_detail qpd l...

2024-09-24

0 54

题解 | #找出每个学校GPA最低的同学#

select device_id, university, gpa from user_profile x where gpa <= all(select gpa from user_profile y where x.university = y.university) order by u...

2024-09-24

0 53