白加黑__

分类

/ 注册

全部文章（共49篇）

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

WITH fd AS (SELECT user_id, MIN(date) first_date FROM login GROUP BY user_id), second_day_log_num AS (SELECT ...

2025-03-06

0 58

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

WITH t1 AS ( SELECT de.dept_no, max(s.salary) maxSalary FROM dept_emp de JOIN salaries s ON de.emp_no = s.emp_no GROUP...

2025-03-06

0 59

题解 | 重载运算

class Coordinate: def __init__(self, x, y): self.x = x self.y = y def __str__(self): return f'({self.x}, {self.y})' ...

2025-02-27

0 59

题解 | 修改属性2

class Employee: def __init__(self, name, salary) -> None: self.name = name self.salary = salary def printclass(self): ...

2025-02-27

0 61

题解 | 修改属性1

class Employee: def __init__(self, name, salary): self.name = name self.salary = salary def printclass(self): try: ...

2025-02-27

0 60

题解 | 兔子的数量

def recursion(i): if i == 1: return 2 elif i == 2: return 3 else: return recursion(i-1) + recursion(i-2)i = int(input())...

2025-02-26

0 77

题解 | 班级管理

class Student: def __init__(self, name, id, score, level): self.name = name self.id = id self.score = score self.l...

2025-02-26

0 65

题解 | 商品销售总额分布

SELECT IF(LENGTH(ucl.pay_method) = 0, 'error', ucl.pay_method), COUNT(*) cnt FROM user_client_log ucl JOIN product_info pi ON pi.product_id = ...

2025-02-26

1 66

题解 | 商品销售排名

SELECT pi.product_name, CAST(SUM(pi.price) AS SIGNED) total_sales FROM user_client_log ucl JOIN product_info pi ON pi.product_id = ucl.produc...

2025-02-26

0 54

题解 | 牛牛的矩阵相加

num = int(input()) matrix = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] for i in range(len(matrix)): a = [] for j in matrix[i]: a.append(j * num...

2025-02-25

0 65