笑一下a

分类

/ 注册

全部文章（共14篇）

题解 | #未完成试卷数大于1的有效用户#

SELECT uid, sum(case when submit_time is null then 1 else 0 end) incomplete_cnt, sum(case when submit_time is not null then 1 else 0 end) complete_cn...

2024-10-29

0 39

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

select a3.dept_no,a3.dept_name,a4.summ from departments a3 left join ( select a1.dept_no, count(salary) summ from dept_emp a1 left join salaries a2 on...

2024-10-25

0 43

题解 | #查找在职员工自入职以来的薪水涨幅情况#

select emp_no,diff growth from( select a3.emp_no, a4.salary-a3.salary diff from (select a1.emp_no, a2.salary from employees a1 left join salaries a2 ...

2024-10-25

0 54

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

select name product_name,sum(quantity) total_sales,rank()over(partition by category order by sum(quantity)desc) category_rank from products a join ord...

2024-08-10

4 185