准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共35篇）

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

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 78

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

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

2025-04-07

0 121

题解 | 统计用户获得积分

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 79

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

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 75

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

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

2025-04-06

0 68

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

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 90

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

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 73

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

SELECT o.user_id,COUNT(DISTINCT v.visit_time) AS visit_numsFROM order_tb AS o JOIN visit_tb AS v ON o.user_id = v.user_idWHERE DATE(o.order_time) = '...

2025-04-06

4 78

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

SELECT a.date, CONCAT (ROUND(od / nd * 100, 1), '%') AS cr FROM ( SELECT DATE (o.order_time) AS date, COUN...

2025-04-06

0 68

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

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

2025-03-23

0 98