白加黑__
白加黑__
全部文章
分类
归档
标签
去牛客网
登录
/
注册
白加黑__的博客
全部文章
(共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
首页
上一页
1
2
3
4
5
下一页
末页