灏哥

分类

/ 注册

全部文章（共3篇）

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

select date(order_time) as order_date, ot.user_id, count(order_time) as order_nums, vip from order_tb ot join uservip_tb ut on ot....

2025-12-24

0 16

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

select o.user_id, count(distinct v.visit_time)as visit_nums from order_tb as o right join visit_tb as v on o.user_id=v.user_id where date(o.or...

2025-05-29

0 57

题解 | 统计所有课程参加培训人次

select sum(case when course is null then 0 when course like '%,%,%' then 3 when course like '%,%' then 2 else 1 end) as staff_nums from cultiv...

2025-05-09

0 56