题解 | #牛客的课程订单分析(七)#

select

case when client_id !=0 then name else 'GroupBuy' end A,

count(*)

from order_info left join client on order_info.client_id = client.id

where date > '2025-10-15' and status like 'c%' and product_name in ('c++','java','python') and user_id in (select user_id from order_info where date > '2025-10-15' and status like 'c%' and product_name in ('c++','java','python') group by user_id having count(*)>=2)

group by client_id

order by A ASC

我懂了，我最后一直在按client_id排序，也是不知道为什么。（甚至不是client.name）

晕掉。难怪排序一直排不对