SQL gets the script _mssql of the sorted data after grouping

First the previous code, as follows:

Copy Code code 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 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 means to get each distributor in each county city in two categories of customers
Take the first 3 months of the total number of customers in the top 10% customers to investigate.