牛客821079062号

分类

/ 注册

全部文章（共12篇）

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

SELECT vip, count(*) as visit_nums, count(distinct user_id) as visit_users from visit_tb JOIN uservip_tb USING(user_id) GROUP BY vip order by visit_nu...

2025-02-18

0 67

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

SELECT user_id,count(*) AS visit_nums FROM visit_tb WHERE user_id in ( SELECT user_id FROM order_tb WHERE DATE(order_time) = '2022-09-02' ) ...

2025-02-18

0 60