五首绝句哈
五首绝句哈
全部文章
分类
归档
标签
去牛客网
登录
/
注册
五首绝句哈的博客
全部文章
(共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
首页
上一页
1
2
3
4
下一页
末页