准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共28篇）

题解 | 统计加班员工占比

SELECT s.department,CONCAT(ROUND(COALESCE(c.overtime_work,0) /COUNT(*)*100,1),'%') AS ratio FROM staff_tb AS s JOIN attendent_tb AS a ON a.staff_id...

2025-04-11

0 26

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

SELECT st.department ,ROUND(AVG(sa.normal_salary-sa.dock_salary),3) AS avg_salary FROM staff_tb AS st JOIN salary_tb AS sa ON st.staff_id=sa.staff_i...

2025-04-11

0 32

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

SELECT DATE(order_time) AS order_date , o.user_id, count(*) AS order_nums , u.vip FROM order_tb AS o JOIN uservip_tb AS u ON o.user_id=u.user_id GRO...

2025-04-11

0 21

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

SELECT u.user_id, u.point+COALESCE(total_cunsume,0) AS point FROM uservip_tb AS u LEFT JOIN ( SELECT u.user_id ,SUM(o.order_price) AS total_cunsum...

2025-04-11

0 30

题解 | 用pandas查看牛客网用户数据

import pandas as pd Nowcoder_data = pd.read_csv('Nowcoder.csv',sep=',',dtype=object) print(Nowcoder_data.head(6))

2025-04-07

0 39

题解 | 统计用户获得积分

SELECT user_id,SUM( TRUNCATE((TIME_TO_SEC(TIMEDIFF(leave_time,visit_time))/60)/10,0)) AS point FROM visit_tb WHERE TIME_TO_SEC(TIMEDIFF(leave_time,vi...

2025-04-06

0 34

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

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

2025-04-06

0 28

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

SELECT user_idFROM ( SELECT r.user_id, DATE ( LEAD (log_time, 2, '1990-01-01') over ( ...

2025-04-06

0 35

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

SELECT u.vip, COUNT(info_id) AS visit_nums, COUNT(DISTINCT v.user_id) AS visit_usersFROM visit_tb AS v JOIN uservip_tb AS u ON v.user_i...

2025-04-06

0 41

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

SELECT u.vip , COALESCE(SUM(o.order_price) ,0) AS order_totalFROM order_tb AS o RIGHT JOIN uservip_tb AS u ON o.user_id = u.user_idGROUP BY u.vipO...

2025-04-06

0 30