JJJENNN

分类

/ 注册

全部文章（共38篇）

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

SELECT DATE(order_time) AS order_date, user_id, COUNT(order_id) AS order_nums, vip FROM order_tb LEFT JOIN uservip_tb USING (user_id) ...

2026-02-16

0 30

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

SELECT user_id, u.point + SUM(order_price) AS point FROM order_tb o LEFT JOIN uservip_tb u USING (user_id) WHERE order_price > 100 GROUP ...

2026-02-16

0 30

题解 | 统计用户获得积分

SELECT user_id, FLOOR(SUM(TIMESTAMPDIFF(minute, visit_time,leave_time)/10)) AS point FROM visit_tb GROUP BY user_id ORDER BY point DESC

2026-02-16

0 34

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

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

2026-02-16

0 31

题解 | 获取指定客户每月的消费额

SELECT DATE_FORMAT(t.t_time, '%Y-%m') AS time, ROUND(SUM(t.t_amount),1) AS total FROM trade t JOIN customer c ON t.t_cus = c.c_id WHERE c.c_id = ...

2026-02-16

0 30

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

WITH visit_user AS( SELECT COUNT(DISTINCT user_id) AS visit_num, DATE(visit_time) AS date FROM visit_tb GROUP BY DATE(visit_time) ), o...

2026-02-13

0 25

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

SELECT user_id, COUNT(info_id) AS visit_nums FROM visit_tb WHERE user_id IN( SELECT user_id FROM order_tb WHERE DATE(order_time) = '2022-0...

2026-02-13

0 19

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

SELECT vip, IFNULL(SUM(order_price),0) AS order_total FROM order_tb RIGHT JOIN uservip_tb USING (user_id) GROUP BY vip ORDER BY order_total D...

2026-02-13

0 30

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

SELECT ut.vip, COUNT(user_id) AS visit_nums, COUNT(DISTINCT user_id) AS visit_users FROM visit_tb vt JOIN uservip_tb ut USING (user_id) GR...

2026-02-13

0 30

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

SELECT user_id FROM ( SELECT *, date_sub(DATE(log_time), INTERVAL rn DAY) as dt FROM ( ...

2026-02-13

0 26