coding的佩奇酱

分类

/ 注册

全部文章（共25篇）

题解 | #获得积分最多的人(二)#

select id,name,grade_num from (select *, dense_rank() over(order by grade_num desc) as rn from (select g1.user_id as id, u1.name, sum(grade_num) as ...

2023-07-12

0 328

题解 | #查找薪水记录超过15条的员工号emp_no

select emp_no,count(1) as cnt from salaries group by emp_no having cnt > 15;

2023-07-12

0 320

题解 | #统计复旦用户8月练题情况#

select up.device_id, up.university, coalesce(count(up.device_id),0), coalesce(count(case when qpd.result = 'right' then 1 end),null) from user_profil...

2023-05-30

0 188

题解 | #找出每个学校GPA最低的同学#

select device_id, university, gpa from (select *,row_number() over(partition by university order by gpa asc) as rn from user_profile) tmp where rn =...

2023-05-09

0 194

题解 | #操作符混合运用#

select device_id,gender,age,university,gpa from user_profile where gpa>3.5 and university = '山东大学' or gpa>3.8 and university = '复旦大学';

2023-02-15

0 191