存几分期许

分类

/ 注册

全部文章（共167篇）

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

select a.staff_id, staff_name, concat(round(dock_salary/normal_salary*100, 1), '%') as dock_ratio from staff_tb a join salary_tb b on a.staff_id=b.st...

2025-08-07

0 26

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

WITH t1 AS (SELECT user_id, DATE_FORMAT(order_time, '%Y-%m-%d') AS order_time FROM order_tb GROUP BY user_id, DATE_FORMAT(orde...

2025-08-07

0 38

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

with t1 as ( select user_id, date_format(order_time, '%Y-%m-%d') as order_time from order_tb group by user_id, date_format(order_time, '%Y...

2025-08-07

0 36

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

with t1 as ( select distinct user_id from order_tb where date_format(order_time, '%Y-%m-%d')='2022-09-02' ), t2 as ( select user_id ...

2025-08-07

0 42

题解 | 统计各等级会员用户下订单总额

select vip, ifnull(sum(b.order_price), 0) as order_total from uservip_tb a left join order_tb b on a.user_id=b.user_id group by vip order by order_tot...

2025-08-07

0 28

题解 | 统计商家不同会员每日访问人次及访问人数

select vip, count(1) as visit_nums, count(distinct a.user_id) as visit_users from visit_tb a join uservip_tb b on a.user_id=b.user_id group by vip ord...

2025-08-07

0 31

题解 | 查询连续登陆的用户

select user_id from ( select reg.user_id, log_time, date_sub(date(log_time), interval row_number() over (partition by reg.user_id order by log...

2025-08-07

0 26

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

select post, round(avg(timestampdiff(second, first_clockin, last_clockin)/60/60), 3) as work_hours from staff_tb staff join attendent_tb att on staff...

2025-08-07

0 24

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

select round(avg(score), 3) as avg_score from ( select rec_info_l, rec_user from recommend_tb group by rec_info_l, rec_user ) a join user_...

2025-08-07

0 19

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

select b.staff_id, staff_name from staff_tb a join cultivate_tb b on a.staff_id=b.staff_id where course like '%course3%' order by b.staff_id

2025-08-07

0 28