SQL script for retrieving data After grouping and sorting

First, the Code is as follows:
Copy codeThe Code is as follows:
Select distinct
B. OrgID, B. CompanyID, B. AreaID, B. CustChannelID, B. CustID, B. SaleTotalQty,
GETDATE () from KDS400TelSurveyCustAll_Temp as tmp1 cross apply
(
Select top 10 percent * from KDS400TelSurveyCustAll_Temp tmp2
Where tmp1.OrgID = tmp2.OrgID and tmp1.CompanyID = tmp2.CompanyID
And tmp1.AreaID = tmp2.AreaID and tmp1.CustChannelID = tmp2.CustChannelID
And tmp2.CustChannelID in (1027,1028)
Order by tmp2.OrgID, tmp2.CompanyID, tmp2.AreaID, tmp2.AreaType, tmp2.CustChannelID
) As B

This code is used to obtain two types of customers from each dealer in each county-level city.
The top 10% customers with the cumulative sales volume in the first three months of various customers were investigated.