五首绝句哈

分类

/ 注册

全部文章（共33篇）

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

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

2025-06-18

1 10

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

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

2025-06-18

1 10

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

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 9