白加黑__

分类

/ 注册

全部文章（共49篇）

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

WITH ts AS ( SELECT merchant_id, SUM(sale_amount) total_sales_amount FROM sales_underline GROUP BY merchant_id ), tr AS ( ...

2025-06-26

0 44

题解 | 判断一个链表是否为回文结构

class ListNode: def __init__(self, x): self.val = x self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param head L...

2025-06-12

0 72

题解 | 统计各个部门的工资记录数

SELECT d.dept_no, d.dept_name, COUNT(*) sum FROM dept_emp de JOIN departments d ON d.dept_no = de.dept_no JOIN salaries s ON s.emp_no = de...

2025-06-11

0 42

题解 | 两个链表的第一个公共结点

class ListNode: def __init__(self, x): self.val = x self.next = None class Solution: def FindFirstCommonNode(self , pHead1 ,...

2025-06-11

0 45

题解 | 链表中倒数最后k个结点

class ListNode: def __init__(self, x): self.val = x self.next = None class Solution: def FindKthToTail(self , pHead: ListNode...

2025-06-11

0 61

题解 | 判断链表中是否有环

class ListNode: def __init__(self, x): self.val = x self.next = None # @param head ListNode类 # @return bool布尔型 # class Solution:...

2025-06-10

0 39

题解 | 反转链表（递归解法）

class ListNode: def __init__(self, x): self.val = x self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param head L...

2025-06-05

0 48

题解 | 未下单用户登陆渠道统计

SELECT ui.channel, COUNT(*) cnt FROM order_log ol RIGHT JOIN user_info ui ON ol.uid = ui.uid WHERE ol.order_id IS NULL GROUP BY ui.channel ORD...

2025-05-26

0 48

题解 | 返回顾客名称和相关订单号以及每个订单的总价

SELECT c.cust_name, o.order_num, oi.quantity * oi.item_price OrderTotal FROM Customers c JOIN Orders o ON c.cust_id = o.cust_id JOIN Order...

2025-05-19

0 57

题解 | 更新员工信息表

WITH t1 AS( SELECT employee_id, max(update_dt) UPDATE_DT FROM EMPLOYEE_UPDATE GROUP BY employee_id ) SELECT t1.EMPLOYEE_ID, IF(t1.UPD...

2025-05-19

1 53