夸克__

分类

/ 注册

全部文章（共5篇）

题解 | 分组过滤练习题

/* select university, round(avg(question_cnt),3) as avg_question_cnt, round(avg(answer_cnt),3) as avg_answer_cnt from user_profile group by university...

2025-10-27

0 13

题解 | 查找GPA最高值

/*select round(max(gpa),1) as gpa from user_profile where university='复旦大学'; */ select round(gpa,1) as gpa from user_profile where university='复旦大学' ...

2025-10-27

1 10

题解 | 统计加班员工占比

select s.department, concat( round( sum( case when timestampdiff(second, first_clockin...

2025-10-23

1 10

题解 | 统计各个部门平均薪资

select a.department, round(avg(b.normal_salary - b.dock_salary), 3) as avg_salary from staff_tb as a join salary_tb as b on a.staff_id...

2025-10-23

1 13

题解 | 查询单日多次下订单的用户信息？

select date(order_time) as order_date, o.user_id, count(order_time) as order_nums, u.vip from order_tb o join uservip_tb u on o.user_id=u.user_id grou...

2025-10-23

1 11