1.获得每个用户每个订单信息、购买次数、按日期的排序select *,count(user_id)over(partition by user_id) cnt,Row_number()over(partition by user_id order by date) r from order_info where DATEDIFF(date,'2025-10-15') >0 and product_name in ('C++','Java','Python') and status ='completed';t1 2.获得购买次数为...