准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共35篇）

题解 | 统计各岗位员工平均工作时长

SELECT s.post, ROUND( AVG( TIMESTAMPDIFF (SECOND, a.first_clockin, a.last_clockin) ) / 3600, 3 ) AS wo...

2025-03-23

0 116

题解 | 每个商品的销售总额

SELECT name AS product_name, SUM(quantity) as total_sales, ROW_NUMBER() OVER ( PARTITION BY p.category ORDER B...

2025-03-19

0 100

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

SELECT ROUND( SUM(DISTINCT u.score) / COUNT(DISTINCT u.user_id), 3 ) AS avg_score FROM recommend_tb as r JOIN user_act...

2025-03-19

0 80

题解 | 查询培训指定课程的员工信息

SELECT s.staff_id, s.staff_name FROM staff_tb as s JOIN cultivate_tb AS c ON s.staff_id = c.staff_id WHERE c.course LIKE '%3' ORDE...

2025-03-19

0 83

题解 | 统计所有课程参加培训人次

SELECT ROUND( SUM( LENGTH (REPLACE (course, ',', '')) / LENGTH ('course1') ), 0 ) as staff_nums FROM c...

2025-03-19

0 60