题目链接:点击打开链接题目大意:略。解题思路:注意解决方案(2)中 date_format 用法。AC 代码-- 解决方案(1)WITH t1 AS( SELECT s.*, e.department_id FROM salary s JOIN employee e ON s.employee_id = e.employee_id ),t2 AS( SELECT SUBSTRING(pay_date, 1, 7) pay_month, AVG(amount
# 力扣(LeetCode)
2023-10-15
55 点赞
0 评论
83 浏览