牛客479560235号

分类

/ 注册

全部文章（共50篇）

题解 | 所有用户对高难度题目的刷题数

SELECT a.device_id, IFNULL(b.question_cnt,0) question_cnt FROM user_profile a LEFT JOIN ( SELECT t1.device_id,COUNT(t2.question_id) quest...

2025-04-23

0 30

题解 | 平均绩点大于3.6且总人数大于2的学校里学生情况

WITH university_name AS( SELECT university FROM user_profile GROUP BY university HAVING AVG(gpa)>3.6 AND COUNT(id)>2 ), univ...

2025-04-23

0 27

题解 | 存在绩点大于该校平均绩点时的学生信息

WITH avg_gpa AS( SELECT university,AVG(gpa) avg_g FROM user_profile GROUP BY university HAVING AVG(gpa) >3.6 ) SELECT t1.device_id...

2025-04-22

0 20

题解 | 存在绩点大于该校平均绩点时的学生信息

WITH avg_gpa AS( SELECT university,AVG(gpa) avg_g FROM user_profile GROUP BY university HAVING AVG(gpa) >3.6 ) SELECT t1.device_id...

2025-04-22

0 17

题解 | 最受欢迎的top3课程

SELECT a.cid,a.play_cnt pv,a.time_len FROM( SELECT t1.cid, COUNT(*) play_cnt, SUM(timestampdiff(minute,t2.start_time,t2.en...

2025-04-21

0 27

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

With t_salary AS( SELECT t1.department, ROUND(AVG(t2.normal_salary - t2.dock_salary),2) avg_salary FROM staff_tb t1 INNER JOI...

2025-04-17

0 25

题解 | 统计每个产品的销售情况

with max_sales as ( SELECT product_id max_product_id, DATE_format (order_date, '%Y%m') M_order_date, S...

2025-04-17

0 33

题解 | 商品价格排名

SELECT a.product_id,a.product_name,a.type,a.price FROM( SELECT *,DENSE_RANK() OVER(partition by type order by price DESC) ranking FROM product...

2025-04-14

0 30

题解 | 统计快递运输时长

SELECT t1.exp_type,ROUND(AVG(TIMESTAMPDIFF(second,out_time,in_time)/3600),1) time FROM express_tb t1 RIGHT JOIN exp_action_tb t2 ON t1.exp_number = t2...

2025-04-11

0 26

题解 | 完成员工考核试卷突出的非领导员工

with avg_exam AS ( SELECT exam_id,AVG(score) avg_score,AVG(timestampdiff(second,start_time,submit_time)) avg_time FROM exam_record GROUP ...

2025-04-10

0 25