蚊抑青年小王

分类

/ 注册

全部文章（共24篇）

题解 | 分析客户逾期情况

select pay_ability,concat(round(t1.overdue_num/t2.total_num*100,1),'%') overdue_ratio from (select ct.pay_ability,count(lt.overdue_days) overdue_num f...

2025-03-04

0 76

题解 | 每个月Top3的周杰伦歌曲

select nt.month, nt.ranking, nt.song_name, nt.play_pv from ( select t.month, row_number() over ( ...

2025-03-02

0 57

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

select de.dept_no, de.emp_no, s.salaryfrom dept_emp de join salaries s on de.emp_no = s.emp_no join ( select de.de...

2024-03-24

0 197

题解 |

select prod_name,quant_sold from (select prod_id,sum(quantity) quant_sold from OrderItems group by prod_id) a,Products b where a.prod_id=b.prod_id ;

2023-02-02

0 191