五首绝句哈

分类

/ 注册

全部文章（共38篇）

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

WITH t1 AS( SELECT product_id, round(sum(quantity*unit_price),2) AS total_sales, unit_price, sum(quantity) AS total_quantity, ...

2025-06-18

1 54

题解 | 统计快递运输时长

select exp_type,round(avg(duration),1) AS time FROM( SELECT a.exp_type,round(TIMESTAMPDIFF(MINUTE,b.out_time,b.in_time)/60,1) AS duration F...

2025-06-18

3 53

题解 | 统计加班员工占比

SELECT department,concat(format(avg(CASE WHEN duration > 570 THEN 1 ELSE 0 END)*100,1),'%') AS ratio FROM( SELECT a.staff_id,a.department,r...

2025-06-18

1 40

题解 | 推荐内容准确的用户平均评分

SELECT round(avg(score),2) AS avg_score from( SELECT DISTINCT a.rec_user,b.score FROM recommend_tb AS a JOIN user_action_tb AS b ...

2025-06-18

2 39

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

SELECT department, round(avg(real_salary),2) AS average_actual_salary, IFNULL(round(avg(CASE WHEN staff_gender = 'male' THEN real_salary END),2),0) AS...

2025-06-18

0 47

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

WITH t AS ( SELECT a.emp_id, b.emp_level, TIMESTAMPDIFF(SECOND, a.start_time, a.submit_time) AS durati...

2025-06-18

1 58

题解 | 网易云音乐推荐(网易校招笔试真题)

WITH t AS ( SELECT a.music_id, b.music_name FROM ( SELECT DISTINCT ...

2025-06-18

1 50

题解 | 统计用户从访问到下单的转化率

SELECT visit_date AS date, concat(round(avg(CASE WHEN order_date IS NOT NULL THEN 1 ELSE 0 END)*100,1),'%') AS cr FROM( SELECT DISTINCT date(a.vis...

2025-06-18

1 50