wenzo_

分类

/ 注册

全部文章（共31篇）

题解 | 每天登陆最早的用户的内容喜好

SELECT log_day, user_id, hobby FROM( SELECT l.user_id, DATE(log_time) AS log_day, DENSE_RANK() OVER(PARTITION BY DATE(log_time...

2025-02-13

0 53

题解 | 统计加班员工占比

SELECT department, CONCAT(ROUND(100 * SUM(IF(time_diff > 9.5, 1, 0)) / COUNT(staff_name), 1), '%') AS ratio FROM( SELECT depar...

2025-02-13

0 65

题解 | 统计各个部门平均薪资

SELECT department, ROUND(AVG(real_salary), 3) AS avg_salary FROM( SELECT department, normal_salary - dock_salary AS real_s...

2025-02-12

0 47

题解 | 查询单日多次下订单的用户信息？

SELECT DATE(order_time) AS order_date, o.user_id, COUNT(order_time) AS order_nums, vip FROM order_tb o JOIN uservip_tb u ON o.user_id ...

2025-02-12

6 68

题解 | 更新用户积分信息？

SELECT o.user_id, point + SUM(order_price) AS point FROM order_tb o JOIN uservip_tb u ON o.user_id = u.user_id WHERE order_price > 100 GRO...

2025-02-12

5 42

题解 | 统计用户获得积分

SELECT user_id, SUM(time_diff) AS point FROM( SELECT user_id, FLOOR(TIMESTAMPDIFF(MINUTE, visit_time, leave_time) / 10) AS...

2025-02-12

1 49

题解 | 统计员工薪资扣除比例

SELECT sta.staff_id, staff_name, CONCAT(ROUND(100 * dock_salary / normal_salary, 1), '%') AS dock_ratio FROM staff_tb sta JOIN salary_tb ...

2025-02-12

0 49

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

SELECT visit_date AS date, CONCAT(ROUND(100 * order_cnt / visit_cnt, 1), '%') AS cr FROM( SELECT DATE(leave_time) AS visit_date, COUNT...

2025-02-12

0 62

题解 | 查询下订单用户访问次数？

SELECT vt.user_id, COUNT(leave_time) AS visit_numsFROM visit_tb vtJOIN( SELECT DISTINCT user_id AS user_id, DATE(order_time) AS...

2025-02-12

0 45

题解 | #牛客直播各科目出勤率#

SELECT c.course_id, c.course_name, ROUND(SUM(IF(online_time >= 10 AND if_sign = 1, 1, 0)) / SUM(if_sign) * 100, 2) AS 'attend_rate(%)' FR...

2024-12-03

0 44