有朋友可以帮忙看看这个题怎么写吗

SELECT A.user_id,A.user_sex,B.sku+B.sku_name,SUM(pay_amount) AS price FROM dbo.A INNER JOIN B ON A.sku = B.sku INNER JOIN C ON A.sku = C.sku WHERE user_id IN (SELECT USER_ID FROM( SELECT TOP(10)user_id,SUM(order_quantity) FROM A WHERE CONVERT(DATETIME,order_dt,120) = '2023-01' GROUP BY user_id)us) GROUP BY A.user_id,A.user_sex,B.sku+B.sku_name ORDER BY user_id,price desc

不算很难，下班回家写一下，今天第一天实习

目前想到的是1.先group by 订单表，sum订单数量，order by 之后limit 10 2.第一步的临时表结果 left join 订单表 3.group by 用户，sku 按照用户和金额排序

这不是挺基础的

我也不会，我是菜鸡

有思路了吗uu