Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Percentage by Rank(Top Percentages) (oracle 19c)
Oracle Percentage by Rank(Top Percentages) [message #690133] Tue, 22 October 2024 21:08 Go to next message
born2achieve
Messages: 14
Registered: July 2012
Junior Member
Hello,

Please find the below test data and i have product name and sold quantity and ranked this already. i would need to apply top 50% product by Sold_Quantity or rank should be categorize as “TOP Selling”, 50% to 75% should be categorize  as “Medium Selling” and 75% to 100% as “Low Selling”.  I gave the sample data. in original, total number of rows may vary. so, these % should apply accordingly.  Final result, i would need the column as Product_Name, Sold_Quantity,Rank, Category(Top/Medium/Low). How to achieve this. any sample query please

Sample Data:
With Sample as (
select 'CS-1302737' as Product_Name,8315 as Sold_Quantity,1 as Rank  from dual union all
select 'CS-6198202' as Product_Name,8186 as Sold_Quantity,2 as Rank  from dual union all
select 'CS-6193899' as Product_Name,5258 as Sold_Quantity,3 as Rank  from dual union all
select 'CS-1304429' as Product_Name,4616 as Sold_Quantity,4 as Rank  from dual union all
select 'CS-6112576' as Product_Name,4297 as Sold_Quantity,5 as Rank  from dual union all
select 'CS-6198203' as Product_Name,4127 as Sold_Quantity,6 as Rank  from dual union all
select 'CS-5860437' as Product_Name,4017 as Sold_Quantity,7 as Rank  from dual union all
select 'CS-6113063' as Product_Name,3407 as Sold_Quantity,8 as Rank  from dual union all
select 'CS-6190969' as Product_Name,3127 as Sold_Quantity,9 as Rank  from dual union all
select 'CS-6191263' as Product_Name,3070 as Sold_Quantity,10 as Rank  from dual union all
select 'CS-6004977' as Product_Name,2801 as Sold_Quantity,11 as Rank  from dual union all
select 'CS-6193150' as Product_Name,2749 as Sold_Quantity,12 as Rank  from dual union all
select 'CS-6112998' as Product_Name,2696 as Sold_Quantity,13 as Rank  from dual union all
select 'CS-6113064' as Product_Name,2644 as Sold_Quantity,14 as Rank  from dual union all
select 'CS-4800022' as Product_Name,2450 as Sold_Quantity,15 as Rank  from dual union all
select 'CS-6110197' as Product_Name,2448 as Sold_Quantity,16 as Rank  from dual union all
select 'CS-6193897' as Product_Name,2443 as Sold_Quantity,17 as Rank  from dual union all
select 'CS-5105903' as Product_Name,2322 as Sold_Quantity,18 as Rank  from dual union all
select 'CS-1501189' as Product_Name,2042 as Sold_Quantity,19 as Rank  from dual union all
select 'CS-5051034' as Product_Name,2023 as Sold_Quantity,20 as Rank  from dual union all
select 'CS-6194395' as Product_Name,1983 as Sold_Quantity,21 as Rank  from dual union all
select 'CS-6112496' as Product_Name,1947 as Sold_Quantity,22 as Rank  from dual union all
select 'CS-6007962' as Product_Name,1920 as Sold_Quantity,23 as Rank  from dual union all
select 'CS-6112594' as Product_Name,1910 as Sold_Quantity,24 as Rank  from dual union all
select 'CS-6113638' as Product_Name,1897 as Sold_Quantity,25 as Rank  from dual union all
select 'CS-3100112' as Product_Name,1865 as Sold_Quantity,26 as Rank  from dual union all
select 'CS-2401285' as Product_Name,1730 as Sold_Quantity,27 as Rank  from dual union all
select 'CS-6192003' as Product_Name,1725 as Sold_Quantity,28 as Rank  from dual union all
select 'CS-6195622' as Product_Name,1663 as Sold_Quantity,29 as Rank  from dual union all
select 'CS-6113828' as Product_Name,1650 as Sold_Quantity,30 as Rank  from dual union all
select 'CS-4207011' as Product_Name,1561 as Sold_Quantity,31 as Rank  from dual union all
select 'CS-6113826' as Product_Name,1559 as Sold_Quantity,32 as Rank  from dual union all
select 'CS-4301197' as Product_Name,1558 as Sold_Quantity,33 as Rank  from dual union all
select 'CS-6111748' as Product_Name,1548 as Sold_Quantity,34 as Rank  from dual union all
select 'CS-6112595' as Product_Name,1544 as Sold_Quantity,35 as Rank  from dual union all
select 'CS-6111747' as Product_Name,1444 as Sold_Quantity,36 as Rank  from dual union all
select 'CS-4203815' as Product_Name,1441 as Sold_Quantity,37 as Rank  from dual union all
select 'CS-6003917' as Product_Name,1441 as Sold_Quantity,38 as Rank  from dual union all
select 'CS-6113720' as Product_Name,1413 as Sold_Quantity,39 as Rank  from dual union all
select 'CS-6190870' as Product_Name,1412 as Sold_Quantity,40 as Rank  from dual union all
select 'CS-6111884' as Product_Name,1411 as Sold_Quantity,41 as Rank  from dual union all
select 'CS-2470355Z' as Product_Name,1406 as Sold_Quantity,42 as Rank  from dual union all
select 'CS-6112597' as Product_Name,1309 as Sold_Quantity,43 as Rank  from dual union all
select 'CS-3001697' as Product_Name,1308 as Sold_Quantity,44 as Rank  from dual union all
select 'CS-6113724' as Product_Name,1306 as Sold_Quantity,45 as Rank  from dual union all
select 'CS-4803001' as Product_Name,1266 as Sold_Quantity,46 as Rank  from dual union all
select 'CS-6191724' as Product_Name,1242 as Sold_Quantity,47 as Rank  from dual union all
select 'CS-6021013' as Product_Name,1227 as Sold_Quantity,48 as Rank  from dual union all
select 'CS-4207000' as Product_Name,1217 as Sold_Quantity,49 as Rank  from dual union all
select 'CS-6113684' as Product_Name,1206 as Sold_Quantity,50 as Rank  from dual union all
select 'CS-6113799' as Product_Name,1201 as Sold_Quantity,51 as Rank  from dual union all
select 'CS-4800008' as Product_Name,1169 as Sold_Quantity,52 as Rank  from dual union all
select 'CS-5861029' as Product_Name,1160 as Sold_Quantity,53 as Rank  from dual union all
select 'CS-8300239' as Product_Name,1156 as Sold_Quantity,54 as Rank  from dual union all
select 'CS-5201826Z' as Product_Name,1139 as Sold_Quantity,55 as Rank  from dual union all
select 'CS-4100027' as Product_Name,1126 as Sold_Quantity,56 as Rank  from dual union all
select 'CS-2470303Z' as Product_Name,1119 as Sold_Quantity,57 as Rank  from dual union all
select 'CS-3009914' as Product_Name,1115 as Sold_Quantity,58 as Rank  from dual union all
select 'CS-1501145' as Product_Name,1108 as Sold_Quantity,59 as Rank  from dual union all
select 'CS-6005377' as Product_Name,1100 as Sold_Quantity,60 as Rank  from dual union all
select 'CS-6112994' as Product_Name,1091 as Sold_Quantity,61 as Rank  from dual union all
select 'CS-6191726' as Product_Name,1087 as Sold_Quantity,62 as Rank  from dual union all
select 'CS-3011434B' as Product_Name,1075 as Sold_Quantity,63 as Rank  from dual union all
select 'CS-6004976' as Product_Name,1072 as Sold_Quantity,64 as Rank  from dual union all
select 'CS-4301192' as Product_Name,1057 as Sold_Quantity,65 as Rank  from dual union all
select 'CS-8400850' as Product_Name,1038 as Sold_Quantity,66 as Rank  from dual union all
select 'CS-3400793' as Product_Name,1031 as Sold_Quantity,67 as Rank  from dual union all
select 'CS-3202804' as Product_Name,1029 as Sold_Quantity,68 as Rank  from dual union all
select 'CS-4203139' as Product_Name,1026 as Sold_Quantity,69 as Rank  from dual union all
select 'CS-3400785' as Product_Name,1018 as Sold_Quantity,70 as Rank  from dual union all
select 'CS-4800007' as Product_Name,1010 as Sold_Quantity,71 as Rank  from dual union all
select 'CS-4600008' as Product_Name,988 as Sold_Quantity,72 as Rank  from dual union all
select 'CS-3001173' as Product_Name,976 as Sold_Quantity,73 as Rank  from dual union all
select 'CS-6004311' as Product_Name,965 as Sold_Quantity,74 as Rank  from dual union all
select 'CS-4204440' as Product_Name,960 as Sold_Quantity,75 as Rank  from dual union all
select 'CS-4809948' as Product_Name,938 as Sold_Quantity,76 as Rank  from dual union all
select 'CS-6199942' as Product_Name,906 as Sold_Quantity,77 as Rank  from dual union all
select 'CS-3400794' as Product_Name,886 as Sold_Quantity,78 as Rank  from dual union all
select 'CS-6007963' as Product_Name,886 as Sold_Quantity,79 as Rank  from dual union all
select 'CS-1501034' as Product_Name,880 as Sold_Quantity,80 as Rank  from dual union all
select 'CS-2402900' as Product_Name,867 as Sold_Quantity,81 as Rank  from dual union all
select 'CS-1511042' as Product_Name,864 as Sold_Quantity,82 as Rank  from dual union all
select 'CS-6021329' as Product_Name,863 as Sold_Quantity,83 as Rank  from dual union all
select 'CS-3400796' as Product_Name,861 as Sold_Quantity,84 as Rank  from dual union all
select 'CS-6190099' as Product_Name,848 as Sold_Quantity,85 as Rank  from dual union all
select 'CS-6113824' as Product_Name,840 as Sold_Quantity,86 as Rank  from dual union all
select 'CS-5050027' as Product_Name,817 as Sold_Quantity,87 as Rank  from dual union all
select 'CS-6004005' as Product_Name,814 as Sold_Quantity,88 as Rank  from dual union all
select 'CS-4400094' as Product_Name,813 as Sold_Quantity,89 as Rank  from dual union all
select 'CS-6000403' as Product_Name,813 as Sold_Quantity,90 as Rank  from dual union all
select 'CS-6004978' as Product_Name,800 as Sold_Quantity,91 as Rank  from dual union all
select 'CS-4600007' as Product_Name,798 as Sold_Quantity,92 as Rank  from dual union all
select 'CS-4207030' as Product_Name,795 as Sold_Quantity,93 as Rank  from dual union all
select 'CS-6101448' as Product_Name,794 as Sold_Quantity,94 as Rank  from dual union all
select 'CS-3004139' as Product_Name,783 as Sold_Quantity,95 as Rank  from dual union all
select 'CS-6021328' as Product_Name,769 as Sold_Quantity,96 as Rank  from dual union all
select 'CS-3400784' as Product_Name,766 as Sold_Quantity,97 as Rank  from dual union all
select 'CS-6113260' as Product_Name,764 as Sold_Quantity,98 as Rank  from dual union all
select 'CS-5861075' as Product_Name,762 as Sold_Quantity,99 as Rank  from dual union all
select 'CS-3400783' as Product_Name,753 as Sold_Quantity,100 as Rank  from dual union all
select 'CS-6021361' as Product_Name,738 as Sold_Quantity,101 as Rank  from dual union all
select 'CS-6021321' as Product_Name,736 as Sold_Quantity,102 as Rank  from dual union all
select 'CS-6112149' as Product_Name,733 as Sold_Quantity,103 as Rank  from dual union all
select 'CS-1401276' as Product_Name,732 as Sold_Quantity,104 as Rank  from dual union all
select 'CS-3400780' as Product_Name,727 as Sold_Quantity,105 as Rank  from dual union all
select 'CS-5811214' as Product_Name,727 as Sold_Quantity,106 as Rank  from dual union all
select 'CS-3400781' as Product_Name,723 as Sold_Quantity,107 as Rank  from dual union all
select 'CS-6021331' as Product_Name,721 as Sold_Quantity,108 as Rank  from dual union all
select 'CS-6005378' as Product_Name,718 as Sold_Quantity,109 as Rank  from dual union all
select 'CS-6111875' as Product_Name,717 as Sold_Quantity,110 as Rank  from dual union all
select 'CS-2401289' as Product_Name,714 as Sold_Quantity,111 as Rank  from dual union all
select 'CS-3400791' as Product_Name,714 as Sold_Quantity,112 as Rank  from dual union all
select 'CS-6190057' as Product_Name,713 as Sold_Quantity,113 as Rank  from dual union all
select 'CS-6004013' as Product_Name,705 as Sold_Quantity,114 as Rank  from dual union all
select 'CS-6191178' as Product_Name,703 as Sold_Quantity,115 as Rank  from dual union all
select 'CS-5900027' as Product_Name,702 as Sold_Quantity,116 as Rank  from dual union all
select 'CS-6021362' as Product_Name,701 as Sold_Quantity,117 as Rank  from dual union all
select 'CS-4100074' as Product_Name,698 as Sold_Quantity,118 as Rank  from dual union all
select 'CS-1401274' as Product_Name,695 as Sold_Quantity,119 as Rank  from dual union all
select 'CS-6021310' as Product_Name,688 as Sold_Quantity,120 as Rank  from dual union all
select 'CS-4400226' as Product_Name,687 as Sold_Quantity,121 as Rank  from dual union all
select 'CS-6021312' as Product_Name,687 as Sold_Quantity,122 as Rank  from dual union all
select 'CS-3400795' as Product_Name,685 as Sold_Quantity,123 as Rank  from dual union all
select 'CS-4606666' as Product_Name,685 as Sold_Quantity,124 as Rank  from dual union all
select 'CS-4100053' as Product_Name,680 as Sold_Quantity,125 as Rank  from dual union all
select 'CS-9200099' as Product_Name,673 as Sold_Quantity,126 as Rank  from dual union all
select 'CS-6006883' as Product_Name,667 as Sold_Quantity,127 as Rank  from dual union all
select 'CS-8307070' as Product_Name,662 as Sold_Quantity,128 as Rank  from dual union all
select 'CS-6113825' as Product_Name,661 as Sold_Quantity,129 as Rank  from dual union all
select 'CS-5861039' as Product_Name,658 as Sold_Quantity,130 as Rank  from dual union all
select 'CS-6007589' as Product_Name,653 as Sold_Quantity,131 as Rank  from dual union all
select 'CS-3200609' as Product_Name,650 as Sold_Quantity,132 as Rank  from dual union all
select 'CS-6113919' as Product_Name,650 as Sold_Quantity,133 as Rank  from dual union all
select 'CS-6111525' as Product_Name,650 as Sold_Quantity,134 as Rank  from dual union all
select 'CS-3400788' as Product_Name,650 as Sold_Quantity,135 as Rank  from dual union all
select 'CS-5864040' as Product_Name,643 as Sold_Quantity,136 as Rank  from dual union all
select 'CS-5100206' as Product_Name,640 as Sold_Quantity,137 as Rank  from dual union all
select 'CS-6021322' as Product_Name,633 as Sold_Quantity,138 as Rank  from dual union all
select 'CS-6021330' as Product_Name,632 as Sold_Quantity,139 as Rank  from dual union all
select 'CS-3400790' as Product_Name,624 as Sold_Quantity,140 as Rank  from dual union all
select 'CS-4308851' as Product_Name,616 as Sold_Quantity,141 as Rank  from dual union all
select 'CS-4301193' as Product_Name,615 as Sold_Quantity,142 as Rank  from dual union all
select 'CS-8304125' as Product_Name,615 as Sold_Quantity,143 as Rank  from dual union all
select 'CS-6113715' as Product_Name,602 as Sold_Quantity,144 as Rank  from dual union all
select 'CS-5100137' as Product_Name,596 as Sold_Quantity,145 as Rank  from dual union all
select 'CS-4800021' as Product_Name,594 as Sold_Quantity,146 as Rank  from dual union all
select 'CS-5812156' as Product_Name,594 as Sold_Quantity,147 as Rank  from dual union all
select 'CS-3400787' as Product_Name,589 as Sold_Quantity,148 as Rank  from dual union all
select 'CS-9401400' as Product_Name,583 as Sold_Quantity,149 as Rank  from dual union all
select 'CS-3400789' as Product_Name,582 as Sold_Quantity,150 as Rank  from dual union all
select 'CS-6113716' as Product_Name,578 as Sold_Quantity,151 as Rank  from dual union all
select 'CS-4207007' as Product_Name,577 as Sold_Quantity,152 as Rank  from dual union all
select 'CS-6003309' as Product_Name,572 as Sold_Quantity,153 as Rank  from dual union all
select 'CS-6021320' as Product_Name,570 as Sold_Quantity,154 as Rank  from dual union all
select 'CS-4203816' as Product_Name,564 as Sold_Quantity,155 as Rank  from dual union all
select 'CS-6021315' as Product_Name,564 as Sold_Quantity,156 as Rank  from dual union all
select 'CS-3400779' as Product_Name,558 as Sold_Quantity,157 as Rank  from dual union all
select 'CS-6004982' as Product_Name,558 as Sold_Quantity,158 as Rank  from dual union all
select 'CS-4207021' as Product_Name,558 as Sold_Quantity,159 as Rank  from dual union all
select 'CS-3400798' as Product_Name,557 as Sold_Quantity,160 as Rank  from dual union all
select 'CS-4704772' as Product_Name,557 as Sold_Quantity,161 as Rank  from dual union all
select 'CS-6004983' as Product_Name,556 as Sold_Quantity,162 as Rank  from dual union all
select 'CS-6021323' as Product_Name,550 as Sold_Quantity,163 as Rank  from dual union all
select 'CS-6021311' as Product_Name,549 as Sold_Quantity,164 as Rank  from dual union all
select 'CS-1400004' as Product_Name,547 as Sold_Quantity,165 as Rank  from dual union all
select 'CS-3400775' as Product_Name,543 as Sold_Quantity,166 as Rank  from dual union all
select 'CS-3402149' as Product_Name,541 as Sold_Quantity,167 as Rank  from dual union all
select 'CS-6004987' as Product_Name,541 as Sold_Quantity,168 as Rank  from dual union all
select 'CS-3400776' as Product_Name,539 as Sold_Quantity,169 as Rank  from dual union all
select 'CS-6021314' as Product_Name,537 as Sold_Quantity,170 as Rank  from dual union all
select 'CS-3400774' as Product_Name,529 as Sold_Quantity,171 as Rank  from dual union all
select 'CS-6004984' as Product_Name,529 as Sold_Quantity,172 as Rank  from dual union all
select 'CS-4400291' as Product_Name,527 as Sold_Quantity,173 as Rank  from dual union all
select 'CS-6114551' as Product_Name,527 as Sold_Quantity,174 as Rank  from dual union all
select 'CS-6021332' as Product_Name,527 as Sold_Quantity,175 as Rank  from dual union all
select 'CS-3400777' as Product_Name,526 as Sold_Quantity,176 as Rank  from dual union all
select 'CS-6198203I' as Product_Name,526 as Sold_Quantity,177 as Rank  from dual union all
select 'CS-4407056' as Product_Name,526 as Sold_Quantity,178 as Rank  from dual union all
select 'CS-4207036' as Product_Name,523 as Sold_Quantity,179 as Rank  from dual union all
select 'CS-6021313' as Product_Name,523 as Sold_Quantity,180 as Rank  from dual union all
select 'CS-6021325' as Product_Name,521 as Sold_Quantity,181 as Rank  from dual union all
select 'CS-4601202' as Product_Name,517 as Sold_Quantity,182 as Rank  from dual union all
select 'CS-4400233' as Product_Name,515 as Sold_Quantity,183 as Rank  from dual union all
select 'CS-6004989' as Product_Name,514 as Sold_Quantity,184 as Rank  from dual union all
select 'CS-6113795' as Product_Name,514 as Sold_Quantity,185 as Rank  from dual union all
select 'CS-6006400' as Product_Name,514 as Sold_Quantity,186 as Rank  from dual union all
select 'CS-2000117' as Product_Name,512 as Sold_Quantity,187 as Rank  from dual union all
select 'CS-6021358' as Product_Name,512 as Sold_Quantity,188 as Rank  from dual union all
select 'CS-4101055' as Product_Name,511 as Sold_Quantity,189 as Rank  from dual union all
select 'CS-6004986' as Product_Name,509 as Sold_Quantity,190 as Rank  from dual union all
select 'CS-6006860' as Product_Name,509 as Sold_Quantity,191 as Rank  from dual union all
select 'CS-4400004' as Product_Name,507 as Sold_Quantity,192 as Rank  from dual union all
select 'CS-8400011' as Product_Name,507 as Sold_Quantity,193 as Rank  from dual union all
select 'CS-3001151' as Product_Name,505 as Sold_Quantity,194 as Rank  from dual union all
select 'CS-4209425' as Product_Name,502 as Sold_Quantity,195 as Rank  from dual union all
select 'CS-5102939' as Product_Name,498 as Sold_Quantity,196 as Rank  from dual union all
select 'CS-1500321' as Product_Name,494 as Sold_Quantity,197 as Rank  from dual union all
select 'CS-6111883' as Product_Name,493 as Sold_Quantity,198 as Rank  from dual union all
select 'CS-2470508Z' as Product_Name,491 as Sold_Quantity,199 as Rank  from dual union all
select 'CS-5861048' as Product_Name,489 as Sold_Quantity,200 as Rank  from dual union all
select 'CS-4700946' as Product_Name,486 as Sold_Quantity,201 as Rank  from dual union all
select 'CS-4400158' as Product_Name,481 as Sold_Quantity,202 as Rank  from dual union all
select 'CS-1500322' as Product_Name,476 as Sold_Quantity,203 as Rank  from dual union all
select 'CS-3400772' as Product_Name,468 as Sold_Quantity,204 as Rank  from dual union all
select 'CS-5109036' as Product_Name,462 as Sold_Quantity,205 as Rank  from dual union all
select 'CS-5812157' as Product_Name,462 as Sold_Quantity,206 as Rank  from dual union all
select 'CS-4806002' as Product_Name,460 as Sold_Quantity,207 as Rank  from dual union all
select 'CS-3400770' as Product_Name,458 as Sold_Quantity,208 as Rank  from dual union all
select 'CS-9408772' as Product_Name,458 as Sold_Quantity,209 as Rank  from dual union all
select 'CS-6004981' as Product_Name,456 as Sold_Quantity,210 as Rank  from dual union all
select 'CS-6021333' as Product_Name,456 as Sold_Quantity,211 as Rank  from dual union all
select 'CS-6000400' as Product_Name,453 as Sold_Quantity,212 as Rank  from dual union all
select 'CS-4203465' as Product_Name,451 as Sold_Quantity,213 as Rank  from dual union all
select 'CS-6021324' as Product_Name,448 as Sold_Quantity,214 as Rank  from dual union all
select 'CS-5101180' as Product_Name,446 as Sold_Quantity,215 as Rank  from dual union all
select 'CS-4400016' as Product_Name,444 as Sold_Quantity,216 as Rank  from dual union all
select 'CS-1509993' as Product_Name,442 as Sold_Quantity,217 as Rank  from dual union all
select 'CS-6111538' as Product_Name,442 as Sold_Quantity,218 as Rank  from dual union all
select 'CS-6021363' as Product_Name,440 as Sold_Quantity,219 as Rank  from dual union all
select 'CS-6111616' as Product_Name,440 as Sold_Quantity,220 as Rank  from dual union all
select 'CS-6021080' as Product_Name,439 as Sold_Quantity,221 as Rank  from dual union all
select 'CS-9200101' as Product_Name,439 as Sold_Quantity,222 as Rank  from dual union all
select 'CS-6111617' as Product_Name,439 as Sold_Quantity,223 as Rank  from dual union all
select 'CS-6112902' as Product_Name,432 as Sold_Quantity,224 as Rank  from dual union all
select 'CS-4400292' as Product_Name,427 as Sold_Quantity,225 as Rank  from dual union all
select 'CS-9200553' as Product_Name,426 as Sold_Quantity,226 as Rank  from dual union all
select 'CS-6193150I' as Product_Name,424 as Sold_Quantity,227 as Rank  from dual union all
select 'CS-3001150' as Product_Name,422 as Sold_Quantity,228 as Rank  from dual union all
select 'CS-4400095' as Product_Name,421 as Sold_Quantity,229 as Rank  from dual union all
select 'CS-4100028' as Product_Name,420 as Sold_Quantity,230 as Rank  from dual union all
select 'CS-5101237' as Product_Name,420 as Sold_Quantity,231 as Rank  from dual union all
select 'CS-4100029' as Product_Name,418 as Sold_Quantity,232 as Rank  from dual union all
select 'CS-4203819' as Product_Name,417 as Sold_Quantity,233 as Rank  from dual union all
select 'CS-6021316' as Product_Name,417 as Sold_Quantity,234 as Rank  from dual union all
select 'CS-4203814' as Product_Name,416 as Sold_Quantity,235 as Rank  from dual union all
select 'CS-3400771' as Product_Name,410 as Sold_Quantity,236 as Rank  from dual union all
select 'CS-4207034' as Product_Name,410 as Sold_Quantity,237 as Rank  from dual union all
select 'CS-3402146' as Product_Name,408 as Sold_Quantity,238 as Rank  from dual union all
select 'CS-6005948' as Product_Name,408 as Sold_Quantity,239 as Rank  from dual union all
select 'CS-6022054' as Product_Name,406 as Sold_Quantity,240 as Rank  from dual union all
select 'CS-6113251' as Product_Name,403 as Sold_Quantity,241 as Rank  from dual union all
select 'CS-2470360' as Product_Name,402 as Sold_Quantity,242 as Rank  from dual union all
select 'CS-6007131' as Product_Name,402 as Sold_Quantity,243 as Rank  from dual union all
select 'CS-6113694' as Product_Name,399 as Sold_Quantity,244 as Rank  from dual union all
select 'CS-6111664' as Product_Name,396 as Sold_Quantity,245 as Rank  from dual union all
select 'CS-3400320' as Product_Name,395 as Sold_Quantity,246 as Rank  from dual union all
select 'CS-9301013' as Product_Name,395 as Sold_Quantity,247 as Rank  from dual union all
select 'CS-3400786' as Product_Name,393 as Sold_Quantity,248 as Rank  from dual union all
select 'CS-4400367' as Product_Name,393 as Sold_Quantity,249 as Rank  from dual union all
select 'CS-6021359' as Product_Name,391 as Sold_Quantity,250 as Rank  from dual union all
select 'CS-9207400' as Product_Name,391 as Sold_Quantity,251 as Rank  from dual union all
select 'CS-6110292' as Product_Name,391 as Sold_Quantity,252 as Rank  from dual union all
select 'CS-4400501' as Product_Name,387 as Sold_Quantity,253 as Rank  from dual union all
select 'CS-5201255' as Product_Name,385 as Sold_Quantity,254 as Rank  from dual union all
select 'CS-4400057' as Product_Name,383 as Sold_Quantity,255 as Rank  from dual union all
select 'CS-3009915' as Product_Name,380 as Sold_Quantity,256 as Rank  from dual union all
select 'CS-6001354' as Product_Name,376 as Sold_Quantity,257 as Rank  from dual union all
select 'CS-4400500' as Product_Name,374 as Sold_Quantity,258 as Rank  from dual union all
select 'CS-4606648' as Product_Name,374 as Sold_Quantity,259 as Rank  from dual union all
select 'CS-4209503' as Product_Name,371 as Sold_Quantity,260 as Rank  from dual union all
select 'CS-6002053' as Product_Name,371 as Sold_Quantity,261 as Rank  from dual union all
select 'CS-3007869' as Product_Name,369 as Sold_Quantity,262 as Rank  from dual union all
select 'CS-3402143' as Product_Name,367 as Sold_Quantity,263 as Rank  from dual union all
select 'CS-4406340' as Product_Name,367 as Sold_Quantity,264 as Rank  from dual union all
select 'CS-2470498' as Product_Name,366 as Sold_Quantity,265 as Rank  from dual union all
select 'CS-7201101' as Product_Name,366 as Sold_Quantity,266 as Rank  from dual union all
select 'CS-3001176' as Product_Name,365 as Sold_Quantity,267 as Rank  from dual union all
select 'CS-6007130' as Product_Name,363 as Sold_Quantity,268 as Rank  from dual union all
select 'CS-6021364' as Product_Name,363 as Sold_Quantity,269 as Rank  from dual union all
select 'CS-3201150' as Product_Name,362 as Sold_Quantity,270 as Rank  from dual union all
select 'CS-4400364' as Product_Name,362 as Sold_Quantity,271 as Rank  from dual union all
select 'CS-5100224' as Product_Name,361 as Sold_Quantity,272 as Rank  from dual union all
select 'CS-6004990' as Product_Name,361 as Sold_Quantity,273 as Rank  from dual union all
select 'CS-6021295' as Product_Name,360 as Sold_Quantity,274 as Rank  from dual union all
select 'CS-9200417' as Product_Name,360 as Sold_Quantity,275 as Rank  from dual union all
select 'CS-6021014' as Product_Name,358 as Sold_Quantity,276 as Rank  from dual union all
select 'CS-4301145' as Product_Name,357 as Sold_Quantity,277 as Rank  from dual union all
select 'CS-6004991' as Product_Name,357 as Sold_Quantity,278 as Rank  from dual union all
select 'CS-4400022' as Product_Name,357 as Sold_Quantity,279 as Rank  from dual union all
select 'CS-3010211' as Product_Name,356 as Sold_Quantity,280 as Rank  from dual union all
select 'CS-6006864' as Product_Name,356 as Sold_Quantity,281 as Rank  from dual union all
select 'CS-4301195' as Product_Name,353 as Sold_Quantity,282 as Rank  from dual union all
select 'CS-6005196' as Product_Name,352 as Sold_Quantity,283 as Rank  from dual union all
select 'CS-5100297' as Product_Name,350 as Sold_Quantity,284 as Rank  from dual union all
select 'CS-6003916' as Product_Name,347 as Sold_Quantity,285 as Rank  from dual union all
select 'CS-9304860' as Product_Name,347 as Sold_Quantity,286 as Rank  from dual union all
select 'CS-3401666' as Product_Name,345 as Sold_Quantity,287 as Rank  from dual union all
select 'CS-4401257' as Product_Name,341 as Sold_Quantity,288 as Rank  from dual union all
select 'CS-6006035' as Product_Name,339 as Sold_Quantity,289 as Rank  from dual union all
select 'CS-6193656' as Product_Name,336 as Sold_Quantity,290 as Rank  from dual union all
select 'CS-4700948' as Product_Name,335 as Sold_Quantity,291 as Rank  from dual union all
select 'CS-6021292' as Product_Name,334 as Sold_Quantity,292 as Rank  from dual union all
select 'CS-5100227' as Product_Name,333 as Sold_Quantity,293 as Rank  from dual union all
select 'CS-4400055' as Product_Name,332 as Sold_Quantity,294 as Rank  from dual union all
select 'CS-8400846' as Product_Name,332 as Sold_Quantity,295 as Rank  from dual union all
select 'CS-8401165' as Product_Name,331 as Sold_Quantity,296 as Rank  from dual union all
select 'CS-3001148' as Product_Name,330 as Sold_Quantity,297 as Rank  from dual union all
select 'CS-5816892' as Product_Name,329 as Sold_Quantity,298 as Rank  from dual union all
select 'CS-6021491' as Product_Name,328 as Sold_Quantity,299 as Rank  from dual union all
select 'CS-3201149' as Product_Name,326 as Sold_Quantity,300 as Rank  from dual union all
select 'CS-6005338' as Product_Name,326 as Sold_Quantity,301 as Rank  from dual union all
select 'CS-3400130' as Product_Name,325 as Sold_Quantity,302 as Rank  from dual union all
select 'CS-6021365' as Product_Name,325 as Sold_Quantity,303 as Rank  from dual union all
select 'CS-4100075' as Product_Name,324 as Sold_Quantity,304 as Rank  from dual union all
select 'CS-2401287' as Product_Name,322 as Sold_Quantity,305 as Rank  from dual union all
select 'CS-4405378' as Product_Name,319 as Sold_Quantity,306 as Rank  from dual union all
select 'CS-6004993' as Product_Name,319 as Sold_Quantity,307 as Rank  from dual union all
select 'CS-4400290' as Product_Name,317 as Sold_Quantity,308 as Rank  from dual union all
select 'CS-6005909' as Product_Name,314 as Sold_Quantity,309 as Rank  from dual union all
select 'CS-6021317' as Product_Name,314 as Sold_Quantity,310 as Rank  from dual union all
select 'CS-3200610' as Product_Name,313 as Sold_Quantity,311 as Rank  from dual union all
select 'CS-3011520' as Product_Name,312 as Sold_Quantity,312 as Rank  from dual union all
select 'CS-6192005' as Product_Name,312 as Sold_Quantity,313 as Rank  from dual union all
select 'CS-6005195' as Product_Name,312 as Sold_Quantity,314 as Rank  from dual union all
select 'CS-4400147' as Product_Name,312 as Sold_Quantity,315 as Rank  from dual union all
select 'CS-6021372' as Product_Name,311 as Sold_Quantity,316 as Rank  from dual union all
select 'CS-6007004' as Product_Name,310 as Sold_Quantity,317 as Rank  from dual union all
select 'CS-4202289' as Product_Name,307 as Sold_Quantity,318 as Rank  from dual union all
select 'CS-6021326' as Product_Name,306 as Sold_Quantity,319 as Rank  from dual union all
select 'CS-4801402' as Product_Name,305 as Sold_Quantity,320 as Rank  from dual union all
select 'CS-4207012' as Product_Name,304 as Sold_Quantity,321 as Rank  from dual union all
select 'CS-6002052' as Product_Name,302 as Sold_Quantity,322 as Rank  from dual union all
select 'CS-9200385' as Product_Name,302 as Sold_Quantity,323 as Rank  from dual union all
select 'CS-6021494' as Product_Name,302 as Sold_Quantity,324 as Rank  from dual union all
select 'CS-2402087' as Product_Name,301 as Sold_Quantity,325 as Rank  from dual union all
select 'CS-6006884' as Product_Name,301 as Sold_Quantity,326 as Rank  from dual union all
select 'CS-5105854' as Product_Name,300 as Sold_Quantity,327 as Rank  from dual union all
select 'CS-5101066' as Product_Name,299 as Sold_Quantity,328 as Rank  from dual union all
select 'CS-6116600' as Product_Name,299 as Sold_Quantity,329 as Rank  from dual union all
select 'CS-6007003' as Product_Name,299 as Sold_Quantity,330 as Rank  from dual union all
select 'CS-6005950' as Product_Name,299 as Sold_Quantity,331 as Rank  from dual union all
select 'CS-6004992' as Product_Name,298 as Sold_Quantity,332 as Rank  from dual union all
select 'CS-6111388Z' as Product_Name,298 as Sold_Quantity,333 as Rank  from dual union all
select 'CS-6001201' as Product_Name,297 as Sold_Quantity,334 as Rank  from dual union all
select 'CS-6002340' as Product_Name,295 as Sold_Quantity,335 as Rank  from dual union all
select 'CS-3402187' as Product_Name,294 as Sold_Quantity,336 as Rank  from dual union all
select 'CS-9202445' as Product_Name,294 as Sold_Quantity,337 as Rank  from dual union all
select 'CS-1400312' as Product_Name,293 as Sold_Quantity,338 as Rank  from dual union all
select 'CS-3400773' as Product_Name,293 as Sold_Quantity,339 as Rank  from dual union all
select 'CS-5860417' as Product_Name,291 as Sold_Quantity,340 as Rank  from dual union all
select 'CS-6111004' as Product_Name,291 as Sold_Quantity,341 as Rank  from dual union all
select 'CS-5109106' as Product_Name,290 as Sold_Quantity,342 as Rank  from dual union all
select 'CS-3400782' as Product_Name,289 as Sold_Quantity,343 as Rank  from dual union all
select 'CS-6022053' as Product_Name,288 as Sold_Quantity,344 as Rank  from dual union all
select 'CS-4606649' as Product_Name,287 as Sold_Quantity,345 as Rank  from dual union all
select 'CS-6021318' as Product_Name,287 as Sold_Quantity,346 as Rank  from dual union all
select 'CS-2002485' as Product_Name,286 as Sold_Quantity,347 as Rank  from dual union all
select 'CS-3008983' as Product_Name,285 as Sold_Quantity,348 as Rank  from dual union all
select 'CS-3200611' as Product_Name,283 as Sold_Quantity,349 as Rank  from dual union all
select 'CS-6005366' as Product_Name,283 as Sold_Quantity,350 as Rank  from dual union all
select 'CS-3011519' as Product_Name,282 as Sold_Quantity,351 as Rank  from dual union all
select 'CS-6006882' as Product_Name,282 as Sold_Quantity,352 as Rank  from dual union all
select 'CS-2000525' as Product_Name,281 as Sold_Quantity,353 as Rank  from dual union all
select 'CS-6021493' as Product_Name,281 as Sold_Quantity,354 as Rank  from dual union all
select 'CS-4203813' as Product_Name,280 as Sold_Quantity,355 as Rank  from dual union all
select 'CS-6021490' as Product_Name,280 as Sold_Quantity,356 as Rank  from dual union all
select 'CS-4207043' as Product_Name,279 as Sold_Quantity,357 as Rank  from dual union all
select 'CS-6113853' as Product_Name,279 as Sold_Quantity,358 as Rank  from dual union all
select 'CS-4400370' as Product_Name,277 as Sold_Quantity,359 as Rank  from dual union all
select 'CS-6190468' as Product_Name,277 as Sold_Quantity,360 as Rank  from dual union all
select 'CS-4300878' as Product_Name,275 as Sold_Quantity,361 as Rank  from dual union all
select 'CS-6004980' as Product_Name,275 as Sold_Quantity,362 as Rank  from dual union all
select 'CS-5102766' as Product_Name,275 as Sold_Quantity,363 as Rank  from dual union all
select 'CS-6005474' as Product_Name,274 as Sold_Quantity,364 as Rank  from dual union all
select 'CS-4400056' as Product_Name,272 as Sold_Quantity,365 as Rank  from dual union all
select 'CS-6190009' as Product_Name,272 as Sold_Quantity,366 as Rank  from dual union all
select 'CS-6004988' as Product_Name,272 as Sold_Quantity,367 as Rank  from dual union all
select 'CS-5100109' as Product_Name,272 as Sold_Quantity,368 as Rank  from dual union all
select 'CS-3011521' as Product_Name,271 as Sold_Quantity,369 as Rank  from dual union all
select 'CS-3001607' as Product_Name,270 as Sold_Quantity,370 as Rank  from dual union all
select 'CS-4800055' as Product_Name,270 as Sold_Quantity,371 as Rank  from dual union all
select 'CS-6021492' as Product_Name,269 as Sold_Quantity,372 as Rank  from dual union all
select 'CS-2000119' as Product_Name,268 as Sold_Quantity,373 as Rank  from dual union all
select 'CS-5208998' as Product_Name,268 as Sold_Quantity,374 as Rank  from dual union all
select 'CS-5100304' as Product_Name,268 as Sold_Quantity,375 as Rank  from dual union all
select 'CS-3401658' as Product_Name,266 as Sold_Quantity,376 as Rank  from dual union all
select 'CS-3402177' as Product_Name,266 as Sold_Quantity,377 as Rank  from dual union all
select 'CS-3402179' as Product_Name,265 as Sold_Quantity,378 as Rank  from dual union all
select 'CS-6021319' as Product_Name,265 as Sold_Quantity,379 as Rank  from dual union all
select 'CS-3004607' as Product_Name,264 as Sold_Quantity,380 as Rank  from dual union all
select 'CS-5070003' as Product_Name,263 as Sold_Quantity,381 as Rank  from dual union all
select 'CS-6193151' as Product_Name,263 as Sold_Quantity,382 as Rank  from dual union all
select 'CS-3001603' as Product_Name,262 as Sold_Quantity,383 as Rank  from dual union all
select 'CS-8305066' as Product_Name,262 as Sold_Quantity,384 as Rank  from dual union all
select 'CS-3402167' as Product_Name,261 as Sold_Quantity,385 as Rank  from dual union all
select 'CS-5100153' as Product_Name,261 as Sold_Quantity,386 as Rank  from dual union all
select 'CS-3402185' as Product_Name,261 as Sold_Quantity,387 as Rank  from dual union all
select 'CS-9101013' as Product_Name,260 as Sold_Quantity,388 as Rank  from dual union all
select 'CS-5860418' as Product_Name,259 as Sold_Quantity,389 as Rank  from dual union all
select 'CS-4400232' as Product_Name,257 as Sold_Quantity,390 as Rank  from dual union all
select 'CS-6004995' as Product_Name,257 as Sold_Quantity,391 as Rank  from dual union all
select 'CS-5100192' as Product_Name,257 as Sold_Quantity,392 as Rank  from dual union all
select 'CS-2002488' as Product_Name,256 as Sold_Quantity,393 as Rank  from dual union all
select 'CS-9402099' as Product_Name,256 as Sold_Quantity,394 as Rank  from dual union all
select 'CS-6021327' as Product_Name,256 as Sold_Quantity,395 as Rank  from dual union all
select 'CS-2470137' as Product_Name,256 as Sold_Quantity,396 as Rank  from dual union all
select 'CS-3001600' as Product_Name,254 as Sold_Quantity,397 as Rank  from dual union all
select 'CS-9203169' as Product_Name,254 as Sold_Quantity,398 as Rank  from dual union all
select 'CS-5901043' as Product_Name,254 as Sold_Quantity,399 as Rank  from dual union all
select 'CS-4102599' as Product_Name,254 as Sold_Quantity,400 as Rank  from dual union all
select 'CS-4100069' as Product_Name,253 as Sold_Quantity,401 as Rank  from dual union all
select 'CS-6003320' as Product_Name,253 as Sold_Quantity,402 as Rank  from dual union all
select 'CS-3402165' as Product_Name,251 as Sold_Quantity,403 as Rank  from dual union all
select 'CS-6003904' as Product_Name,251 as Sold_Quantity,404 as Rank  from dual union all
select 'CS-4400229' as Product_Name,250 as Sold_Quantity,405 as Rank  from dual union all
select 'CS-6005949' as Product_Name,250 as Sold_Quantity,406 as Rank  from dual union all
select 'CS-1501021' as Product_Name,249 as Sold_Quantity,407 as Rank  from dual union all
select 'CS-8301009' as Product_Name,249 as Sold_Quantity,408 as Rank  from dual union all
select 'CS-5811214I' as Product_Name,249 as Sold_Quantity,409 as Rank  from dual union all
select 'CS-3009585' as Product_Name,249 as Sold_Quantity,410 as Rank  from dual union all
select 'CS-3203277' as Product_Name,247 as Sold_Quantity,411 as Rank  from dual union all
select 'CS-3401657' as Product_Name,247 as Sold_Quantity,412 as Rank  from dual union all
select 'CS-3008976' as Product_Name,246 as Sold_Quantity,413 as Rank  from dual union all
select 'CS-9201321' as Product_Name,246 as Sold_Quantity,414 as Rank  from dual union all
select 'CS-6191082' as Product_Name,246 as Sold_Quantity,415 as Rank  from dual union all
select 'CS-3400792' as Product_Name,244 as Sold_Quantity,416 as Rank  from dual union all
select 'CS-4709900' as Product_Name,244 as Sold_Quantity,417 as Rank  from dual union all
select 'CS-2400318' as Product_Name,243 as Sold_Quantity,418 as Rank  from dual union all
select 'CS-9203002' as Product_Name,243 as Sold_Quantity,419 as Rank  from dual union all
select 'CS-9202840' as Product_Name,243 as Sold_Quantity,420 as Rank  from dual union all
select 'CS-3005224' as Product_Name,243 as Sold_Quantity,421 as Rank  from dual union all
select 'CS-3402171' as Product_Name,242 as Sold_Quantity,422 as Rank  from dual union all
select 'CS-6191087' as Product_Name,242 as Sold_Quantity,423 as Rank  from dual union all
select 'CS-6110326' as Product_Name,242 as Sold_Quantity,424 as Rank  from dual union all
select 'CS-6002341' as Product_Name,242 as Sold_Quantity,425 as Rank  from dual union all
select 'CS-6005194' as Product_Name,241 as Sold_Quantity,426 as Rank  from dual union all
select 'CS-6005951' as Product_Name,241 as Sold_Quantity,427 as Rank  from dual union all
select 'CS-1505165' as Product_Name,240 as Sold_Quantity,428 as Rank  from dual union all
select 'CS-6006037' as Product_Name,240 as Sold_Quantity,429 as Rank  from dual union all
select 'CS-3009583' as Product_Name,239 as Sold_Quantity,430 as Rank  from dual union all
select 'CS-4701023' as Product_Name,239 as Sold_Quantity,431 as Rank  from dual union all
select 'CS-4200188' as Product_Name,239 as Sold_Quantity,432 as Rank  from dual union all
select 'CS-3402181' as Product_Name,239 as Sold_Quantity,433 as Rank  from dual union all
select 'CS-3401659' as Product_Name,238 as Sold_Quantity,434 as Rank  from dual union all
select 'CS-3402163' as Product_Name,238 as Sold_Quantity,435 as Rank  from dual union all
select 'CS-3001157' as Product_Name,237 as Sold_Quantity,436 as Rank  from dual union all
select 'CS-6005947' as Product_Name,237 as Sold_Quantity,437 as Rank  from dual union all
select 'CS-5101038' as Product_Name,237 as Sold_Quantity,438 as Rank  from dual union all
select 'CS-6004979' as Product_Name,236 as Sold_Quantity,439 as Rank  from dual union all
select 'CS-9202240' as Product_Name,236 as Sold_Quantity,440 as Rank  from dual union all
select 'CS-6021054' as Product_Name,235 as Sold_Quantity,441 as Rank  from dual union all
select 'CS-6021495' as Product_Name,235 as Sold_Quantity,442 as Rank  from dual union all
select 'CS-3009588' as Product_Name,234 as Sold_Quantity,443 as Rank  from dual union all
select 'CS-6112436' as Product_Name,234 as Sold_Quantity,444 as Rank  from dual union all
select 'CS-5201549' as Product_Name,234 as Sold_Quantity,445 as Rank  from dual union all
select 'CS-2470600' as Product_Name,233 as Sold_Quantity,446 as Rank  from dual union all
select 'CS-8300085' as Product_Name,233 as Sold_Quantity,447 as Rank  from dual union all
select 'CS-5201089' as Product_Name,233 as Sold_Quantity,448 as Rank  from dual union all
select 'CS-5104815' as Product_Name,233 as Sold_Quantity,449 as Rank  from dual union all
select 'CS-1304432' as Product_Name,232 as Sold_Quantity,450 as Rank  from dual union all
select 'CS-6112823' as Product_Name,232 as Sold_Quantity,451 as Rank  from dual union all
select 'CS-6005952' as Product_Name,232 as Sold_Quantity,452 as Rank  from dual union all
select 'CS-6004003' as Product_Name,232 as Sold_Quantity,453 as Rank  from dual union all
select 'CS-4209427' as Product_Name,232 as Sold_Quantity,454 as Rank  from dual union all
select 'CS-3009582' as Product_Name,231 as Sold_Quantity,455 as Rank  from dual union all
select 'CS-8300126' as Product_Name,231 as Sold_Quantity,456 as Rank  from dual union all
select 'CS-5105904' as Product_Name,231 as Sold_Quantity,457 as Rank  from dual union all
select 'CS-3401656' as Product_Name,230 as Sold_Quantity,458 as Rank  from dual union all
select 'CS-9200539' as Product_Name,230 as Sold_Quantity,459 as Rank  from dual union all
select 'CS-3402183' as Product_Name,230 as Sold_Quantity,460 as Rank  from dual union all
select 'CS-5050023L' as Product_Name,228 as Sold_Quantity,461 as Rank  from dual union all
select 'CS-9200323' as Product_Name,228 as Sold_Quantity,462 as Rank  from dual union all
select 'CS-3008970' as Product_Name,227 as Sold_Quantity,463 as Rank  from dual union all
select 'CS-3402169' as Product_Name,227 as Sold_Quantity,464 as Rank  from dual union all
select 'CS-3008994' as Product_Name,227 as Sold_Quantity,465 as Rank  from dual union all
select 'CS-4900425' as Product_Name,226 as Sold_Quantity,466 as Rank  from dual union all
select 'CS-6194436' as Product_Name,226 as Sold_Quantity,467 as Rank  from dual union all
select 'CS-6006036' as Product_Name,226 as Sold_Quantity,468 as Rank  from dual union all
select 'CS-3008978' as Product_Name,225 as Sold_Quantity,469 as Rank  from dual union all
select 'CS-3401664' as Product_Name,225 as Sold_Quantity,470 as Rank  from dual union all
select 'CS-3008985' as Product_Name,224 as Sold_Quantity,471 as Rank  from dual union all
select 'CS-4400297' as Product_Name,223 as Sold_Quantity,472 as Rank  from dual union all
select 'CS-1401277' as Product_Name,222 as Sold_Quantity,473 as Rank  from dual union all
select 'CS-3008973' as Product_Name,222 as Sold_Quantity,474 as Rank  from dual union all
select 'CS-3008987' as Product_Name,221 as Sold_Quantity,475 as Rank  from dual union all
select 'CS-6194980' as Product_Name,220 as Sold_Quantity,476 as Rank  from dual union all
select 'CS-3008971' as Product_Name,219 as Sold_Quantity,477 as Rank  from dual union all
select 'CS-6193147' as Product_Name,219 as Sold_Quantity,478 as Rank  from dual union all
select 'CS-6006401' as Product_Name,219 as Sold_Quantity,479 as Rank  from dual union all
select 'CS-4100251' as Product_Name,219 as Sold_Quantity,480 as Rank  from dual union all
select 'CS-3008975' as Product_Name,218 as Sold_Quantity,481 as Rank  from dual union all
select 'CS-6009850' as Product_Name,218 as Sold_Quantity,482 as Rank  from dual union all
select 'CS-6006863' as Product_Name,218 as Sold_Quantity,483 as Rank  from dual union all
select 'CS-3008974' as Product_Name,217 as Sold_Quantity,484 as Rank  from dual union all
select 'CS-4304964' as Product_Name,216 as Sold_Quantity,485 as Rank  from dual union all
select 'CS-8302439' as Product_Name,216 as Sold_Quantity,486 as Rank  from dual union all
select 'CS-6006413' as Product_Name,216 as Sold_Quantity,487 as Rank  from dual union all
select 'CS-4209420' as Product_Name,215 as Sold_Quantity,488 as Rank  from dual union all
select 'CS-7201086' as Product_Name,215 as Sold_Quantity,489 as Rank  from dual union all
select 'CS-3008972' as Product_Name,214 as Sold_Quantity,490 as Rank  from dual union all
select 'CS-5201254' as Product_Name,214 as Sold_Quantity,491 as Rank  from dual union all
select 'CS-4207038' as Product_Name,214 as Sold_Quantity,492 as Rank  from dual union all
select 'CS-3401665' as Product_Name,214 as Sold_Quantity,493 as Rank  from dual union all
select 'CS-3402145' as Product_Name,213 as Sold_Quantity,494 as Rank  from dual union all
select 'CS-9101028' as Product_Name,213 as Sold_Quantity,495 as Rank  from dual union all
select 'CS-3008977' as Product_Name,212 as Sold_Quantity,496 as Rank  from dual union all
select 'CS-7203300' as Product_Name,212 as Sold_Quantity,497 as Rank  from dual union all
select 'CS-3401655' as Product_Name,211 as Sold_Quantity,498 as Rank  from dual union all
select 'CS-5072036' as Product_Name,211 as Sold_Quantity,499 as Rank  from dual union all
select 'CS-4400296' as Product_Name,211 as Sold_Quantity,500 as Rank  from dual union all
select 'CS-3401653' as Product_Name,210 as Sold_Quantity,501 as Rank  from dual union all
select 'CS-6006415' as Product_Name,210 as Sold_Quantity,502 as Rank  from dual union all
select 'CS-9200352' as Product_Name,209 as Sold_Quantity,503 as Rank  from dual union all
select 'CS-3001602' as Product_Name,208 as Sold_Quantity,504 as Rank  from dual union all
select 'CS-6190004' as Product_Name,208 as Sold_Quantity,505 as Rank  from dual union all
select 'CS-5811117' as Product_Name,208 as Sold_Quantity,506 as Rank  from dual union all
select 'CS-4405530' as Product_Name,208 as Sold_Quantity,507 as Rank  from dual union all
select 'CS-3008992' as Product_Name,208 as Sold_Quantity,508 as Rank  from dual union all
select 'CS-3008991' as Product_Name,208 as Sold_Quantity,509 as Rank  from dual union all
select 'CS-5861041' as Product_Name,206 as Sold_Quantity,510 as Rank  from dual union all
select 'CS-4309820' as Product_Name,205 as Sold_Quantity,511 as Rank  from dual union all
select 'CS-5861005' as Product_Name,205 as Sold_Quantity,512 as Rank  from dual union all
select 'CS-5106805' as Product_Name,205 as Sold_Quantity,513 as Rank  from dual union all
select 'CS-6004994' as Product_Name,203 as Sold_Quantity,514 as Rank  from dual union all
select 'CS-6193112' as Product_Name,203 as Sold_Quantity,515 as Rank  from dual union all
select 'CS-5101018' as Product_Name,202 as Sold_Quantity,516 as Rank  from dual union all
select 'CS-5103356' as Product_Name,202 as Sold_Quantity,517 as Rank  from dual union all
select 'CS-6002712' as Product_Name,201 as Sold_Quantity,518 as Rank  from dual union all
select 'CS-4700950' as Product_Name,200 as Sold_Quantity,519 as Rank  from dual union all
select 'CS-6191262' as Product_Name,200 as Sold_Quantity,520 as Rank  from dual union all
select 'CS-6006038' as Product_Name,200 as Sold_Quantity,521 as Rank  from dual union all
select 'CS-6005953' as Product_Name,200 as Sold_Quantity,522 as Rank  from dual union all
select 'CS-6000641' as Product_Name,200 as Sold_Quantity,523 as Rank  from dual union all
select 'CS-5107629' as Product_Name,200 as Sold_Quantity,524 as Rank  from dual union all
select 'CS-5050026' as Product_Name,200 as Sold_Quantity,525 as Rank  from dual union all
select 'CS-3001604' as Product_Name,199 as Sold_Quantity,526 as Rank  from dual union all
select 'CS-8300240' as Product_Name,199 as Sold_Quantity,527 as Rank  from dual union all
select 'CS-6005188' as Product_Name,199 as Sold_Quantity,528 as Rank  from dual union all
select 'CS-5102938' as Product_Name,199 as Sold_Quantity,529 as Rank  from dual union all
select 'CS-3008980' as Product_Name,199 as Sold_Quantity,530 as Rank  from dual union all
select 'CS-3001695' as Product_Name,198 as Sold_Quantity,531 as Rank  from dual union all
select 'CS-6110492' as Product_Name,198 as Sold_Quantity,532 as Rank  from dual union all
select 'CS-5107764' as Product_Name,198 as Sold_Quantity,533 as Rank  from dual union all
select 'CS-5862500' as Product_Name,197 as Sold_Quantity,534 as Rank  from dual union all
select 'CS-9202400' as Product_Name,197 as Sold_Quantity,535 as Rank  from dual union all
select 'CS-3008989' as Product_Name,196 as Sold_Quantity,536 as Rank  from dual union all
select 'CS-4400156' as Product_Name,196 as Sold_Quantity,537 as Rank  from dual union all
select 'CS-2401290' as Product_Name,195 as Sold_Quantity,538 as Rank  from dual union all
select 'CS-3009460' as Product_Name,194 as Sold_Quantity,539 as Rank  from dual union all
select 'CS-4800024' as Product_Name,194 as Sold_Quantity,540 as Rank  from dual union all
select 'CS-3401663' as Product_Name,194 as Sold_Quantity,541 as Rank  from dual union all
select 'CS-9300126' as Product_Name,193 as Sold_Quantity,542 as Rank  from dual union all
select 'CS-5050006' as Product_Name,192 as Sold_Quantity,543 as Rank  from dual union all
select 'CS-9306506' as Product_Name,192 as Sold_Quantity,544 as Rank  from dual union all
select 'CS-8302011' as Product_Name,192 as Sold_Quantity,545 as Rank  from dual union all
select 'CS-6021369' as Product_Name,192 as Sold_Quantity,546 as Rank  from dual union all
select 'CS-6021047' as Product_Name,192 as Sold_Quantity,547 as Rank  from dual union all
select 'CS-6002784' as Product_Name,192 as Sold_Quantity,548 as Rank  from dual union all
select 'CS-5100169' as Product_Name,192 as Sold_Quantity,549 as Rank  from dual union all
select 'CS-3008979' as Product_Name,191 as Sold_Quantity,550 as Rank  from dual union all
select 'CS-6164322' as Product_Name,191 as Sold_Quantity,551 as Rank  from dual union all
select 'CS-2002482' as Product_Name,190 as Sold_Quantity,552 as Rank  from dual union all
select 'CS-3001155' as Product_Name,189 as Sold_Quantity,553 as Rank  from dual union all
select 'CS-6113798' as Product_Name,189 as Sold_Quantity,554 as Rank  from dual union all
select 'CS-3200612' as Product_Name,187 as Sold_Quantity,555 as Rank  from dual union all
select 'CS-9203995' as Product_Name,187 as Sold_Quantity,556 as Rank  from dual union all
select 'CS-4402925' as Product_Name,187 as Sold_Quantity,557 as Rank  from dual union all
select 'CS-4400121' as Product_Name,186 as Sold_Quantity,558 as Rank  from dual union all
select 'CS-9208015' as Product_Name,186 as Sold_Quantity,559 as Rank  from dual union all
select 'CS-8400580' as Product_Name,186 as Sold_Quantity,560 as Rank  from dual union all
select 'CS-3008993' as Product_Name,185 as Sold_Quantity,561 as Rank  from dual union all
select 'CS-9300030' as Product_Name,185 as Sold_Quantity,562 as Rank  from dual union all
select 'CS-3402147' as Product_Name,185 as Sold_Quantity,563 as Rank  from dual union all
select 'CS-3009576' as Product_Name,185 as Sold_Quantity,564 as Rank  from dual union all
select 'CS-3009572' as Product_Name,185 as Sold_Quantity,565 as Rank  from dual union all
select 'CS-3001152' as Product_Name,184 as Sold_Quantity,566 as Rank  from dual union all
select 'CS-9202131' as Product_Name,184 as Sold_Quantity,567 as Rank  from dual union all
select 'CS-6021477' as Product_Name,184 as Sold_Quantity,568 as Rank  from dual union all
select 'CS-5101322' as Product_Name,183 as Sold_Quantity,569 as Rank  from dual union all
select 'CS-3011518' as Product_Name,182 as Sold_Quantity,570 as Rank  from dual union all
select 'CS-6191232' as Product_Name,182 as Sold_Quantity,571 as Rank  from dual union all
select 'CS-6003353' as Product_Name,182 as Sold_Quantity,572 as Rank  from dual union all
select 'CS-3008982' as Product_Name,181 as Sold_Quantity,573 as Rank  from dual union all
select 'CS-6004019' as Product_Name,181 as Sold_Quantity,574 as Rank  from dual union all
select 'CS-3008968' as Product_Name,180 as Sold_Quantity,575 as Rank  from dual union all
select 'CS-6114125' as Product_Name,180 as Sold_Quantity,576 as Rank  from dual union all
select 'CS-6113693' as Product_Name,180 as Sold_Quantity,577 as Rank  from dual union all
select 'CS-4203818' as Product_Name,180 as Sold_Quantity,578 as Rank  from dual union all
select 'CS-3402173' as Product_Name,180 as Sold_Quantity,579 as Rank  from dual union all
select 'CS-3009562' as Product_Name,180 as Sold_Quantity,580 as Rank  from dual union all
select 'CS-5860527' as Product_Name,179 as Sold_Quantity,581 as Rank  from dual union all
select 'CS-3001601' as Product_Name,178 as Sold_Quantity,582 as Rank  from dual union all
select 'CS-6007001' as Product_Name,178 as Sold_Quantity,583 as Rank  from dual union all
select 'CS-4409447' as Product_Name,178 as Sold_Quantity,584 as Rank  from dual union all
select 'CS-3011522' as Product_Name,177 as Sold_Quantity,585 as Rank  from dual union all
select 'CS-6006859' as Product_Name,177 as Sold_Quantity,586 as Rank  from dual union all
select 'CS-5866578' as Product_Name,177 as Sold_Quantity,587 as Rank  from dual union all
select 'CS-4700123' as Product_Name,177 as Sold_Quantity,588 as Rank  from dual union all
select 'CS-4301232' as Product_Name,177 as Sold_Quantity,589 as Rank  from dual union all
select 'CS-3401662' as Product_Name,177 as Sold_Quantity,590 as Rank  from dual union all
select 'CS-5100300' as Product_Name,176 as Sold_Quantity,591 as Rank  from dual union all
select 'CS-6005193' as Product_Name,176 as Sold_Quantity,592 as Rank  from dual union all
select 'CS-3009587' as Product_Name,175 as Sold_Quantity,593 as Rank  from dual union all
select 'CS-9200510' as Product_Name,175 as Sold_Quantity,594 as Rank  from dual union all
select 'CS-6194215' as Product_Name,175 as Sold_Quantity,595 as Rank  from dual union all
select 'CS-6113642' as Product_Name,175 as Sold_Quantity,596 as Rank  from dual union all
select 'CS-4402545' as Product_Name,175 as Sold_Quantity,597 as Rank  from dual union all
select 'CS-3009569' as Product_Name,174 as Sold_Quantity,598 as Rank  from dual union all
select 'CS-8307178' as Product_Name,174 as Sold_Quantity,599 as Rank  from dual union all
select 'CS-4405507' as Product_Name,174 as Sold_Quantity,600 as Rank  from dual union all
select 'CS-3401654' as Product_Name,173 as Sold_Quantity,601 as Rank  from dual union all
select 'CS-9200046' as Product_Name,173 as Sold_Quantity,602 as Rank  from dual union all
select 'CS-3402193' as Product_Name,173 as Sold_Quantity,603 as Rank  from dual union all
select 'CS-5100333' as Product_Name,172 as Sold_Quantity,604 as Rank  from dual union all
select 'CS-6191728' as Product_Name,172 as Sold_Quantity,605 as Rank  from dual union all
select 'CS-5105134' as Product_Name,172 as Sold_Quantity,606 as Rank  from dual union all
select 'CS-2470361' as Product_Name,171 as Sold_Quantity,607 as Rank  from dual union all
select 'CS-5100963' as Product_Name,171 as Sold_Quantity,608 as Rank  from dual union all
select 'CS-1400025' as Product_Name,170 as Sold_Quantity,609 as Rank  from dual union all
select 'CS-4300855' as Product_Name,170 as Sold_Quantity,610 as Rank  from dual union all
select 'CS-3004740' as Product_Name,170 as Sold_Quantity,611 as Rank  from dual union all
select 'CS-9302416' as Product_Name,169 as Sold_Quantity,612 as Rank  from dual union all
select 'CS-3009584' as Product_Name,168 as Sold_Quantity,613 as Rank  from dual union all
select 'CS-9100400' as Product_Name,168 as Sold_Quantity,614 as Rank  from dual union all
select 'CS-6021466' as Product_Name,168 as Sold_Quantity,615 as Rank  from dual union all
select 'CS-6020684' as Product_Name,168 as Sold_Quantity,616 as Rank  from dual union all
select 'CS-6002339' as Product_Name,168 as Sold_Quantity,617 as Rank  from dual union all
select 'CS-3401650' as Product_Name,167 as Sold_Quantity,618 as Rank  from dual union all
select 'CS-6021467' as Product_Name,167 as Sold_Quantity,619 as Rank  from dual union all
select 'CS-3402161' as Product_Name,167 as Sold_Quantity,620 as Rank  from dual union all
select 'CS-2390124' as Product_Name,166 as Sold_Quantity,621 as Rank  from dual union all
select 'CS-9300059' as Product_Name,166 as Sold_Quantity,622 as Rank  from dual union all
select 'CS-6113264' as Product_Name,166 as Sold_Quantity,623 as Rank  from dual union all
select 'CS-4402780' as Product_Name,166 as Sold_Quantity,624 as Rank  from dual union all
select 'CS-4400023' as Product_Name,166 as Sold_Quantity,625 as Rank  from dual union all
select 'CS-4200196' as Product_Name,166 as Sold_Quantity,626 as Rank  from dual union all
select 'CS-3009586' as Product_Name,166 as Sold_Quantity,627 as Rank  from dual union all
select 'CS-3009575' as Product_Name,164 as Sold_Quantity,628 as Rank  from dual union all
select 'CS-9200014' as Product_Name,164 as Sold_Quantity,629 as Rank  from dual union all
select 'CS-1301739B' as Product_Name,163 as Sold_Quantity,630 as Rank  from dual union all
select 'CS-9202495' as Product_Name,163 as Sold_Quantity,631 as Rank  from dual union all
select 'CS-9200311' as Product_Name,163 as Sold_Quantity,632 as Rank  from dual union all
select 'CS-1400997' as Product_Name,163 as Sold_Quantity,633 as Rank  from dual union all
select 'CS-6112486' as Product_Name,162 as Sold_Quantity,634 as Rank  from dual union all
select 'CS-9100432' as Product_Name,162 as Sold_Quantity,635 as Rank  from dual union all
select 'CS-7200036' as Product_Name,162 as Sold_Quantity,636 as Rank  from dual union all
select 'CS-6112942' as Product_Name,162 as Sold_Quantity,637 as Rank  from dual union all
select 'CS-3009571' as Product_Name,161 as Sold_Quantity,638 as Rank  from dual union all
select 'CS-6001456' as Product_Name,161 as Sold_Quantity,639 as Rank  from dual union all
select 'CS-5102910' as Product_Name,161 as Sold_Quantity,640 as Rank  from dual union all
select 'CS-4700951' as Product_Name,161 as Sold_Quantity,641 as Rank  from dual union all
select 'CS-3009570' as Product_Name,160 as Sold_Quantity,642 as Rank  from dual union all
select 'CS-9202004' as Product_Name,160 as Sold_Quantity,643 as Rank  from dual union all
select 'CS-4500126' as Product_Name,159 as Sold_Quantity,644 as Rank  from dual union all
select 'CS-9201335' as Product_Name,159 as Sold_Quantity,645 as Rank  from dual union all
select 'CS-8306800' as Product_Name,159 as Sold_Quantity,646 as Rank  from dual union all
select 'CS-6020493' as Product_Name,159 as Sold_Quantity,647 as Rank  from dual union all
select 'CS-6003324' as Product_Name,159 as Sold_Quantity,648 as Rank  from dual union all
select 'CS-3005034' as Product_Name,158 as Sold_Quantity,649 as Rank  from dual union all
select 'CS-6191088' as Product_Name,158 as Sold_Quantity,650 as Rank  from dual union all
select 'CS-3402191' as Product_Name,158 as Sold_Quantity,651 as Rank  from dual union all
select 'CS-5208999' as Product_Name,157 as Sold_Quantity,652 as Rank  from dual union all
select 'CS-5861078' as Product_Name,156 as Sold_Quantity,653 as Rank  from dual union all
select 'CS-8400853' as Product_Name,156 as Sold_Quantity,654 as Rank  from dual union all
select 'CS-3009055' as Product_Name,155 as Sold_Quantity,655 as Rank  from dual union all
select 'CS-8404034' as Product_Name,155 as Sold_Quantity,656 as Rank  from dual union all
select 'CS-5102004' as Product_Name,155 as Sold_Quantity,657 as Rank  from dual union all
select 'CS-3009574' as Product_Name,155 as Sold_Quantity,658 as Rank  from dual union all
select 'CS-3009069' as Product_Name,154 as Sold_Quantity,659 as Rank  from dual union all
select 'CS-6021366' as Product_Name,154 as Sold_Quantity,660 as Rank  from dual union all
select 'CS-3402199' as Product_Name,154 as Sold_Quantity,661 as Rank  from dual union all
select 'CS-3011528' as Product_Name,153 as Sold_Quantity,662 as Rank  from dual union all
select 'CS-6021487' as Product_Name,153 as Sold_Quantity,663 as Rank  from dual union all
select 'CS-3009054' as Product_Name,152 as Sold_Quantity,664 as Rank  from dual union all
select 'CS-3100018' as Product_Name,152 as Sold_Quantity,665 as Rank  from dual union all
select 'CS-3009563' as Product_Name,152 as Sold_Quantity,666 as Rank  from dual union all
select 'CS-2002486' as Product_Name,151 as Sold_Quantity,667 as Rank  from dual union all
select 'CS-9201001' as Product_Name,151 as Sold_Quantity,668 as Rank  from dual union all
select 'CS-6021360' as Product_Name,151 as Sold_Quantity,669 as Rank  from dual union all
select 'CS-4202987' as Product_Name,151 as Sold_Quantity,670 as Rank  from dual union all
select 'CS-3009573' as Product_Name,151 as Sold_Quantity,671 as Rank  from dual union all
select 'CS-3009457' as Product_Name,150 as Sold_Quantity,672 as Rank  from dual union all
select 'CS-6113796' as Product_Name,150 as Sold_Quantity,673 as Rank  from dual union all
select 'CS-6111004Z' as Product_Name,150 as Sold_Quantity,674 as Rank  from dual union all
select 'CS-3401661' as Product_Name,150 as Sold_Quantity,675 as Rank  from dual union all
select 'CS-3001605' as Product_Name,149 as Sold_Quantity,676 as Rank  from dual union all
select 'CS-9300104' as Product_Name,149 as Sold_Quantity,677 as Rank  from dual union all
select 'CS-6113499' as Product_Name,148 as Sold_Quantity,678 as Rank  from dual union all
select 'CS-9202910' as Product_Name,148 as Sold_Quantity,679 as Rank  from dual union all
select 'CS-9201548' as Product_Name,148 as Sold_Quantity,680 as Rank  from dual union all
select 'CS-3009565' as Product_Name,147 as Sold_Quantity,681 as Rank  from dual union all
select 'CS-9400298' as Product_Name,147 as Sold_Quantity,682 as Rank  from dual union all
select 'CS-6193898' as Product_Name,147 as Sold_Quantity,683 as Rank  from dual union all
select 'CS-6117649' as Product_Name,147 as Sold_Quantity,684 as Rank  from dual union all
select 'CS-6005929' as Product_Name,147 as Sold_Quantity,685 as Rank  from dual union all
select 'CS-5101161' as Product_Name,147 as Sold_Quantity,686 as Rank  from dual union all
select 'CS-4401250' as Product_Name,147 as Sold_Quantity,687 as Rank  from dual union all
select 'CS-3402195' as Product_Name,147 as Sold_Quantity,688 as Rank  from dual union all
select 'CS-3400797' as Product_Name,146 as Sold_Quantity,689 as Rank  from dual union all
select 'CS-9200718' as Product_Name,146 as Sold_Quantity,690 as Rank  from dual union all
select 'CS-6021367' as Product_Name,146 as Sold_Quantity,691 as Rank  from dual union all
select 'CS-3401648' as Product_Name,146 as Sold_Quantity,692 as Rank  from dual union all
select 'CS-2470501' as Product_Name,145 as Sold_Quantity,693 as Rank  from dual union all
select 'CS-9300105' as Product_Name,145 as Sold_Quantity,694 as Rank  from dual union all
select 'CS-6191093' as Product_Name,145 as Sold_Quantity,695 as Rank  from dual union all
select 'CS-6004996' as Product_Name,145 as Sold_Quantity,696 as Rank  from dual union all
select 'CS-5109110' as Product_Name,145 as Sold_Quantity,697 as Rank  from dual union all
select 'CS-3009058' as Product_Name,144 as Sold_Quantity,698 as Rank  from dual union all
select 'CS-9308008' as Product_Name,144 as Sold_Quantity,699 as Rank  from dual union all
select 'CS-6006858' as Product_Name,144 as Sold_Quantity,700 as Rank  from dual union all
select 'CS-6005337' as Product_Name,144 as Sold_Quantity,701 as Rank  from dual union all
select 'CS-4400289' as Product_Name,144 as Sold_Quantity,702 as Rank  from dual union all
select 'CS-3009056' as Product_Name,143 as Sold_Quantity,703 as Rank  from dual union all
select 'CS-9306501' as Product_Name,143 as Sold_Quantity,704 as Rank  from dual union all
select 'CS-4900057' as Product_Name,143 as Sold_Quantity,705 as Rank  from dual union all
select 'CS-3203278' as Product_Name,143 as Sold_Quantity,706 as Rank  from dual union all
select 'CS-3009057' as Product_Name,142 as Sold_Quantity,707 as Rank  from dual union all
select 'CS-6112236' as Product_Name,142 as Sold_Quantity,708 as Rank  from dual union all
select 'CS-6004010' as Product_Name,142 as Sold_Quantity,709 as Rank  from dual union all
select 'CS-6002827' as Product_Name,142 as Sold_Quantity,710 as Rank  from dual union all
select 'CS-6002054' as Product_Name,142 as Sold_Quantity,711 as Rank  from dual union all
select 'CS-5480212' as Product_Name,142 as Sold_Quantity,712 as Rank  from dual union all
select 'CS-4901022' as Product_Name,142 as Sold_Quantity,713 as Rank  from dual union all
select 'CS-4300412' as Product_Name,142 as Sold_Quantity,714 as Rank  from dual union all
select 'CS-3009053' as Product_Name,141 as Sold_Quantity,715 as Rank  from dual union all
select 'CS-9209050' as Product_Name,141 as Sold_Quantity,716 as Rank  from dual union all
select 'CS-9202870' as Product_Name,141 as Sold_Quantity,717 as Rank  from dual union all
select 'CS-3402197' as Product_Name,141 as Sold_Quantity,718 as Rank  from dual union all
select 'CS-3009059' as Product_Name,141 as Sold_Quantity,719 as Rank  from dual union all
select 'CS-2470136' as Product_Name,140 as Sold_Quantity,720 as Rank  from dual union all
select 'CS-9302415' as Product_Name,140 as Sold_Quantity,721 as Rank  from dual union all
select 'CS-6005957' as Product_Name,140 as Sold_Quantity,722 as Rank  from dual union all
select 'CS-6000747' as Product_Name,140 as Sold_Quantity,723 as Rank  from dual union all
select 'CS-5100275' as Product_Name,140 as Sold_Quantity,724 as Rank  from dual union all
select 'CS-3203271' as Product_Name,139 as Sold_Quantity,725 as Rank  from dual union all
select 'CS-4706840' as Product_Name,138 as Sold_Quantity,726 as Rank  from dual union all
select 'CS-6113913' as Product_Name,138 as Sold_Quantity,727 as Rank  from dual union all
select 'CS-6113246' as Product_Name,138 as Sold_Quantity,728 as Rank  from dual union all
select 'CS-6000340' as Product_Name,138 as Sold_Quantity,729 as Rank  from dual union all
select 'CS-2470506' as Product_Name,137 as Sold_Quantity,730 as Rank  from dual union all
select 'CS-9201740' as Product_Name,137 as Sold_Quantity,731 as Rank  from dual union all
select 'CS-6004997' as Product_Name,137 as Sold_Quantity,732 as Rank  from dual union all
select 'CS-5202130' as Product_Name,137 as Sold_Quantity,733 as Rank  from dual union all
select 'CS-4901132' as Product_Name,137 as Sold_Quantity,734 as Rank  from dual union all
select 'CS-4100037' as Product_Name,136 as Sold_Quantity,735 as Rank  from dual union all
select 'CS-9200300' as Product_Name,136 as Sold_Quantity,736 as Rank  from dual union all
select 'CS-6006411' as Product_Name,136 as Sold_Quantity,737 as Rank  from dual union all
select 'CS-4701135' as Product_Name,136 as Sold_Quantity,738 as Rank  from dual union all
select 'CS-3401647' as Product_Name,135 as Sold_Quantity,739 as Rank  from dual union all
select 'CS-9200005' as Product_Name,135 as Sold_Quantity,740 as Rank  from dual union all
select 'CS-6112765' as Product_Name,135 as Sold_Quantity,741 as Rank  from dual union all
select 'CS-4209496' as Product_Name,135 as Sold_Quantity,742 as Rank  from dual union all
select 'CS-3401668' as Product_Name,135 as Sold_Quantity,743 as Rank  from dual union all
select 'CS-3003919' as Product_Name,134 as Sold_Quantity,744 as Rank  from dual union all
select 'CS-6009770' as Product_Name,134 as Sold_Quantity,745 as Rank  from dual union all
select 'CS-6003326' as Product_Name,134 as Sold_Quantity,746 as Rank  from dual union all
select 'CS-3009064' as Product_Name,134 as Sold_Quantity,747 as Rank  from dual union all
select 'CS-1304819' as Product_Name,133 as Sold_Quantity,748 as Rank  from dual union all
select 'CS-6021147' as Product_Name,133 as Sold_Quantity,749 as Rank  from dual union all
select 'CS-6006412' as Product_Name,133 as Sold_Quantity,750 as Rank  from dual union all
select 'CS-5811502' as Product_Name,133 as Sold_Quantity,751 as Rank  from dual union all
select 'CS-4602794' as Product_Name,133 as Sold_Quantity,752 as Rank  from dual union all
select 'CS-4100722' as Product_Name,133 as Sold_Quantity,753 as Rank  from dual union all
select 'CS-3001177' as Product_Name,132 as Sold_Quantity,754 as Rank  from dual union all
select 'CS-9200040' as Product_Name,132 as Sold_Quantity,755 as Rank  from dual union all
select 'CS-6021483' as Product_Name,132 as Sold_Quantity,756 as Rank  from dual union all
select 'CS-6004999' as Product_Name,132 as Sold_Quantity,757 as Rank  from dual union all
select 'CS-5101182' as Product_Name,132 as Sold_Quantity,758 as Rank  from dual union all
select 'CS-4206113' as Product_Name,132 as Sold_Quantity,759 as Rank  from dual union all
select 'CS-4202290' as Product_Name,132 as Sold_Quantity,760 as Rank  from dual union all
select 'CS-3401649' as Product_Name,132 as Sold_Quantity,761 as Rank  from dual union all
select 'CS-3009566' as Product_Name,132 as Sold_Quantity,762 as Rank  from dual union all
select 'CS-3009564' as Product_Name,132 as Sold_Quantity,763 as Rank  from dual union all
select 'CS-3009068' as Product_Name,131 as Sold_Quantity,764 as Rank  from dual union all
select 'CS-6195034' as Product_Name,131 as Sold_Quantity,765 as Rank  from dual union all
select 'CS-6021169' as Product_Name,131 as Sold_Quantity,766 as Rank  from dual union all
select 'CS-6007872' as Product_Name,131 as Sold_Quantity,767 as Rank  from dual union all
select 'CS-6005008' as Product_Name,131 as Sold_Quantity,768 as Rank  from dual union all
select 'CS-5101099' as Product_Name,131 as Sold_Quantity,769 as Rank  from dual union all
select 'CS-4400361' as Product_Name,131 as Sold_Quantity,770 as Rank  from dual union all
select 'CS-4100249' as Product_Name,131 as Sold_Quantity,771 as Rank  from dual union all
select 'CS-3401670' as Product_Name,131 as Sold_Quantity,772 as Rank  from dual union all
select 'CS-3011527' as Product_Name,131 as Sold_Quantity,773 as Rank  from dual union all
select 'CS-3011523' as Product_Name,130 as Sold_Quantity,774 as Rank  from dual union all
select 'CS-6112237' as Product_Name,130 as Sold_Quantity,775 as Rank  from dual union all
select 'CS-6007262' as Product_Name,130 as Sold_Quantity,776 as Rank  from dual union all
select 'CS-6006414' as Product_Name,130 as Sold_Quantity,777 as Rank  from dual union all
select 'CS-5101181' as Product_Name,130 as Sold_Quantity,778 as Rank  from dual union all
select 'CS-4506515' as Product_Name,129 as Sold_Quantity,779 as Rank  from dual union all
select 'CS-9408811' as Product_Name,129 as Sold_Quantity,780 as Rank  from dual union all
select 'CS-6111661' as Product_Name,129 as Sold_Quantity,781 as Rank  from dual union all
select 'CS-3009048' as Product_Name,128 as Sold_Quantity,782 as Rank  from dual union all
select 'CS-9202430' as Product_Name,128 as Sold_Quantity,783 as Rank  from dual union all
select 'CS-9200035' as Product_Name,128 as Sold_Quantity,784 as Rank  from dual union all
select 'CS-8400840' as Product_Name,128 as Sold_Quantity,785 as Rank  from dual union all
select 'CS-6000403Z' as Product_Name,128 as Sold_Quantity,786 as Rank  from dual union all
select 'CS-4409551' as Product_Name,128 as Sold_Quantity,787 as Rank  from dual union all
select 'CS-3009049' as Product_Name,128 as Sold_Quantity,788 as Rank  from dual union all
select 'CS-1511013' as Product_Name,127 as Sold_Quantity,789 as Rank  from dual union all
select 'CS-9202048' as Product_Name,127 as Sold_Quantity,790 as Rank  from dual union all
select 'CS-6111096' as Product_Name,127 as Sold_Quantity,791 as Rank  from dual union all
select 'CS-3402160' as Product_Name,127 as Sold_Quantity,792 as Rank  from dual union all
select 'CS-1303160' as Product_Name,126 as Sold_Quantity,793 as Rank  from dual union all
select 'CS-9201720' as Product_Name,126 as Sold_Quantity,794 as Rank  from dual union all
select 'CS-9200716' as Product_Name,126 as Sold_Quantity,795 as Rank  from dual union all
select 'CS-9100550' as Product_Name,126 as Sold_Quantity,796 as Rank  from dual union all
select 'CS-3009047' as Product_Name,126 as Sold_Quantity,797 as Rank  from dual union all
select 'CS-3003926' as Product_Name,125 as Sold_Quantity,798 as Rank  from dual union all
select 'CS-5100306' as Product_Name,125 as Sold_Quantity,799 as Rank  from dual union all
select 'CS-4700940' as Product_Name,125 as Sold_Quantity,800 as Rank  from dual )

select * from Sample;
Re: Oracle Percentage by Rank(Top Percentages) [message #690134 is a reply to message #690133] Wed, 23 October 2024 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68709
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

SQL> With Sample as (
  2  select 'CS-1302737' as Product_Name,8315 as Sold_Quantity,1 as Rank  from dual union all
  3  select 'CS-6198202' as Product_Name,8186 as Sold_Quantity,2 as Rank  from dual union all
  4  select 'CS-6193899' as Product_Name,5258 as Sold_Quantity,3 as Rank  from dual union all
  5  select 'CS-1304429' as Product_Name,4616 as Sold_Quantity,4 as Rank  from dual union all
  6  select 'CS-6112576' as Product_Name,4297 as Sold_Quantity,5 as Rank  from dual union all
  7  select 'CS-6198203' as Product_Name,4127 as Sold_Quantity,6 as Rank  from dual union all
  8  select 'CS-5860437' as Product_Name,4017 as Sold_Quantity,7 as Rank  from dual union all
  9  select 'CS-6113063' as Product_Name,3407 as Sold_Quantity,8 as Rank  from dual union all
 10  select 'CS-6190969' as Product_Name,3127 as Sold_Quantity,9 as Rank  from dual union all
 11  select 'CS-6191263' as Product_Name,3070 as Sold_Quantity,10 as Rank  from dual union all
 12  select 'CS-6004977' as Product_Name,2801 as Sold_Quantity,11 as Rank  from dual union all
 13  select 'CS-6193150' as Product_Name,2749 as Sold_Quantity,12 as Rank  from dual union all
 14  select 'CS-6112998' as Product_Name,2696 as Sold_Quantity,13 as Rank  from dual union all
 15  select 'CS-6113064' as Product_Name,2644 as Sold_Quantity,14 as Rank  from dual union all
 16  select 'CS-4800022' as Product_Name,2450 as Sold_Quantity,15 as Rank  from dual union all
 17  select 'CS-6110197' as Product_Name,2448 as Sold_Quantity,16 as Rank  from dual union all
 18  select 'CS-6193897' as Product_Name,2443 as Sold_Quantity,17 as Rank  from dual union all
 19  select 'CS-5105903' as Product_Name,2322 as Sold_Quantity,18 as Rank  from dual union all
 20  select 'CS-1501189' as Product_Name,2042 as Sold_Quantity,19 as Rank  from dual union all
 21  select 'CS-5051034' as Product_Name,2023 as Sold_Quantity,20 as Rank  from dual union all
 22  select 'CS-6194395' as Product_Name,1983 as Sold_Quantity,21 as Rank  from dual union all
 23  select 'CS-6112496' as Product_Name,1947 as Sold_Quantity,22 as Rank  from dual union all
 24  select 'CS-6007962' as Product_Name,1920 as Sold_Quantity,23 as Rank  from dual union all
 25  select 'CS-6112594' as Product_Name,1910 as Sold_Quantity,24 as Rank  from dual union all
 26  select 'CS-6113638' as Product_Name,1897 as Sold_Quantity,25 as Rank  from dual union all
 27  select 'CS-3100112' as Product_Name,1865 as Sold_Quantity,26 as Rank  from dual union all
 28  select 'CS-2401285' as Product_Name,1730 as Sold_Quantity,27 as Rank  from dual union all
 29  select 'CS-6192003' as Product_Name,1725 as Sold_Quantity,28 as Rank  from dual union all
 30  select 'CS-6195622' as Product_Name,1663 as Sold_Quantity,29 as Rank  from dual union all
 31  select 'CS-6113828' as Product_Name,1650 as Sold_Quantity,30 as Rank  from dual union all
 32  select 'CS-4207011' as Product_Name,1561 as Sold_Quantity,31 as Rank  from dual union all
 33  select 'CS-6113826' as Product_Name,1559 as Sold_Quantity,32 as Rank  from dual union all
 34  select 'CS-4301197' as Product_Name,1558 as Sold_Quantity,33 as Rank  from dual union all
 35  select 'CS-6111748' as Product_Name,1548 as Sold_Quantity,34 as Rank  from dual union all
 36  select 'CS-6112595' as Product_Name,1544 as Sold_Quantity,35 as Rank  from dual union all
 37  select 'CS-6111747' as Product_Name,1444 as Sold_Quantity,36 as Rank  from dual union all
 38  select 'CS-4203815' as Product_Name,1441 as Sold_Quantity,37 as Rank  from dual union all
 39  select 'CS-6003917' as Product_Name,1441 as Sold_Quantity,38 as Rank  from dual union all
 40  select 'CS-6113720' as Product_Name,1413 as Sold_Quantity,39 as Rank  from dual union all
 41  select 'CS-6190870' as Product_Name,1412 as Sold_Quantity,40 as Rank  from dual union all
 42  select 'CS-6111884' as Product_Name,1411 as Sold_Quantity,41 as Rank  from dual union all
 43  select 'CS-2470355Z' as Product_Name,1406 as Sold_Quantity,42 as Rank  from dual union all
 44  select 'CS-6112597' as Product_Name,1309 as Sold_Quantity,43 as Rank  from dual union all
 45  select 'CS-3001697' as Product_Name,1308 as Sold_Quantity,44 as Rank  from dual union all
 46  select 'CS-6113724' as Product_Name,1306 as Sold_Quantity,45 as Rank  from dual union all
 47  select 'CS-4803001' as Product_Name,1266 as Sold_Quantity,46 as Rank  from dual union all
 48  select 'CS-6191724' as Product_Name,1242 as Sold_Quantity,47 as Rank  from dual union all
 49  select 'CS-6021013' as Product_Name,1227 as Sold_Quantity,48 as Rank  from dual union all
 50  select 'CS-4207000' as Product_Name,1217 as Sold_Quantity,49 as Rank  from dual union all
 51  select 'CS-6113684' as Product_Name,1206 as Sold_Quantity,50 as Rank  from dual union all
 52  select 'CS-6113799' as Product_Name,1201 as Sold_Quantity,51 as Rank  from dual union all
 53  select 'CS-4800008' as Product_Name,1169 as Sold_Quantity,52 as Rank  from dual union all
 54  select 'CS-5861029' as Product_Name,1160 as Sold_Quantity,53 as Rank  from dual union all
 55  select 'CS-8300239' as Product_Name,1156 as Sold_Quantity,54 as Rank  from dual union all
 56  select 'CS-5201826Z' as Product_Name,1139 as Sold_Quantity,55 as Rank  from dual union all
 57  select 'CS-4100027' as Product_Name,1126 as Sold_Quantity,56 as Rank  from dual union all
 58  select 'CS-2470303Z' as Product_Name,1119 as Sold_Quantity,57 as Rank  from dual union all
 59  select 'CS-3009914' as Product_Name,1115 as Sold_Quantity,58 as Rank  from dual union all
 60  select 'CS-1501145' as Product_Name,1108 as Sold_Quantity,59 as Rank  from dual union all
 61  select 'CS-6005377' as Product_Name,1100 as Sold_Quantity,60 as Rank  from dual union all
 62  select 'CS-6112994' as Product_Name,1091 as Sold_Quantity,61 as Rank  from dual union all
 63  select 'CS-6191726' as Product_Name,1087 as Sold_Quantity,62 as Rank  from dual union all
 64  select 'CS-3011434B' as Product_Name,1075 as Sold_Quantity,63 as Rank  from dual union all
 65  select 'CS-6004976' as Product_Name,1072 as Sold_Quantity,64 as Rank  from dual union all
 66  select 'CS-4301192' as Product_Name,1057 as Sold_Quantity,65 as Rank  from dual union all
 67  select 'CS-8400850' as Product_Name,1038 as Sold_Quantity,66 as Rank  from dual union all
 68  select 'CS-3400793' as Product_Name,1031 as Sold_Quantity,67 as Rank  from dual union all
 69  select 'CS-3202804' as Product_Name,1029 as Sold_Quantity,68 as Rank  from dual union all
 70  select 'CS-4203139' as Product_Name,1026 as Sold_Quantity,69 as Rank  from dual union all
 71  select 'CS-3400785' as Product_Name,1018 as Sold_Quantity,70 as Rank  from dual union all
 72  select 'CS-4800007' as Product_Name,1010 as Sold_Quantity,71 as Rank  from dual union all
 73  select 'CS-4600008' as Product_Name,988 as Sold_Quantity,72 as Rank  from dual union all
 74  select 'CS-3001173' as Product_Name,976 as Sold_Quantity,73 as Rank  from dual union all
 75  select 'CS-6004311' as Product_Name,965 as Sold_Quantity,74 as Rank  from dual union all
 76  select 'CS-4204440' as Product_Name,960 as Sold_Quantity,75 as Rank  from dual union all
 77  select 'CS-4809948' as Product_Name,938 as Sold_Quantity,76 as Rank  from dual union all
 78  select 'CS-6199942' as Product_Name,906 as Sold_Quantity,77 as Rank  from dual union all
 79  select 'CS-3400794' as Product_Name,886 as Sold_Quantity,78 as Rank  from dual union all
 80  select 'CS-6007963' as Product_Name,886 as Sold_Quantity,79 as Rank  from dual union all
 81  select 'CS-1501034' as Product_Name,880 as Sold_Quantity,80 as Rank  from dual union all
 82  select 'CS-2402900' as Product_Name,867 as Sold_Quantity,81 as Rank  from dual union all
 83  select 'CS-1511042' as Product_Name,864 as Sold_Quantity,82 as Rank  from dual union all
 84  select 'CS-6021329' as Product_Name,863 as Sold_Quantity,83 as Rank  from dual union all
 85  select 'CS-3400796' as Product_Name,861 as Sold_Quantity,84 as Rank  from dual union all
 86  select 'CS-6190099' as Product_Name,848 as Sold_Quantity,85 as Rank  from dual union all
 87  select 'CS-6113824' as Product_Name,840 as Sold_Quantity,86 as Rank  from dual union all
 88  select 'CS-5050027' as Product_Name,817 as Sold_Quantity,87 as Rank  from dual union all
 89  select 'CS-6004005' as Product_Name,814 as Sold_Quantity,88 as Rank  from dual union all
 90  select 'CS-4400094' as Product_Name,813 as Sold_Quantity,89 as Rank  from dual union all
 91  select 'CS-6000403' as Product_Name,813 as Sold_Quantity,90 as Rank  from dual union all
 92  select 'CS-6004978' as Product_Name,800 as Sold_Quantity,91 as Rank  from dual union all
 93  select 'CS-4600007' as Product_Name,798 as Sold_Quantity,92 as Rank  from dual union all
 94  select 'CS-4207030' as Product_Name,795 as Sold_Quantity,93 as Rank  from dual union all
 95  select 'CS-6101448' as Product_Name,794 as Sold_Quantity,94 as Rank  from dual union all
 96  select 'CS-3004139' as Product_Name,783 as Sold_Quantity,95 as Rank  from dual union all
 97  select 'CS-6021328' as Product_Name,769 as Sold_Quantity,96 as Rank  from dual union all
 98  select 'CS-3400784' as Product_Name,766 as Sold_Quantity,97 as Rank  from dual union all
 99  select 'CS-6113260' as Product_Name,764 as Sold_Quantity,98 as Rank  from dual union all
100  select 'CS-5861075' as Product_Name,762 as Sold_Quantity,99 as Rank  from dual union all
101  select 'CS-3400783' as Product_Name,753 as Sold_Quantity,100 as Rank  from dual union all
102  select 'CS-6021361' as Product_Name,738 as Sold_Quantity,101 as Rank  from dual union all
103  select 'CS-6021321' as Product_Name,736 as Sold_Quantity,102 as Rank  from dual union all
104  select 'CS-6112149' as Product_Name,733 as Sold_Quantity,103 as Rank  from dual union all
105  select 'CS-1401276' as Product_Name,732 as Sold_Quantity,104 as Rank  from dual union all
106  select 'CS-3400780' as Product_Name,727 as Sold_Quantity,105 as Rank  from dual union all
107  select 'CS-5811214' as Product_Name,727 as Sold_Quantity,106 as Rank  from dual union all
108  select 'CS-3400781' as Product_Name,723 as Sold_Quantity,107 as Rank  from dual union all
109  select 'CS-6021331' as Product_Name,721 as Sold_Quantity,108 as Rank  from dual union all
110  select 'CS-6005378' as Product_Name,718 as Sold_Quantity,109 as Rank  from dual union all
111  select 'CS-6111875' as Product_Name,717 as Sold_Quantity,110 as Rank  from dual union all
112  select 'CS-2401289' as Product_Name,714 as Sold_Quantity,111 as Rank  from dual union all
113  select 'CS-3400791' as Product_Name,714 as Sold_Quantity,112 as Rank  from dual union all
114  select 'CS-6190057' as Product_Name,713 as Sold_Quantity,113 as Rank  from dual union all
115  select 'CS-6004013' as Product_Name,705 as Sold_Quantity,114 as Rank  from dual union all
116  select 'CS-6191178' as Product_Name,703 as Sold_Quantity,115 as Rank  from dual union all
117  select 'CS-5900027' as Product_Name,702 as Sold_Quantity,116 as Rank  from dual union all
118  select 'CS-6021362' as Product_Name,701 as Sold_Quantity,117 as Rank  from dual union all
119  select 'CS-4100074' as Product_Name,698 as Sold_Quantity,118 as Rank  from dual union all
120  select 'CS-1401274' as Product_Name,695 as Sold_Quantity,119 as Rank  from dual union all
121  select 'CS-6021310' as Product_Name,688 as Sold_Quantity,120 as Rank  from dual union all
122  select 'CS-4400226' as Product_Name,687 as Sold_Quantity,121 as Rank  from dual union all
123  select 'CS-6021312' as Product_Name,687 as Sold_Quantity,122 as Rank  from dual union all
124  select 'CS-3400795' as Product_Name,685 as Sold_Quantity,123 as Rank  from dual union all
125  select 'CS-4606666' as Product_Name,685 as Sold_Quantity,124 as Rank  from dual union all
126  select 'CS-4100053' as Product_Name,680 as Sold_Quantity,125 as Rank  from dual union all
127  select 'CS-9200099' as Product_Name,673 as Sold_Quantity,126 as Rank  from dual union all
128  select 'CS-6006883' as Product_Name,667 as Sold_Quantity,127 as Rank  from dual union all
129  select 'CS-8307070' as Product_Name,662 as Sold_Quantity,128 as Rank  from dual union all
130  select 'CS-6113825' as Product_Name,661 as Sold_Quantity,129 as Rank  from dual union all
131  select 'CS-5861039' as Product_Name,658 as Sold_Quantity,130 as Rank  from dual union all
132  select 'CS-6007589' as Product_Name,653 as Sold_Quantity,131 as Rank  from dual union all
133  select 'CS-3200609' as Product_Name,650 as Sold_Quantity,132 as Rank  from dual union all
134  select 'CS-6113919' as Product_Name,650 as Sold_Quantity,133 as Rank  from dual union all
135  select 'CS-6111525' as Product_Name,650 as Sold_Quantity,134 as Rank  from dual union all
136  select 'CS-3400788' as Product_Name,650 as Sold_Quantity,135 as Rank  from dual union all
137  select 'CS-5864040' as Product_Name,643 as Sold_Quantity,136 as Rank  from dual union all
138  select 'CS-5100206' as Product_Name,640 as Sold_Quantity,137 as Rank  from dual union all
139  select 'CS-6021322' as Product_Name,633 as Sold_Quantity,138 as Rank  from dual union all
140  select 'CS-6021330' as Product_Name,632 as Sold_Quantity,139 as Rank  from dual union all
141  select 'CS-3400790' as Product_Name,624 as Sold_Quantity,140 as Rank  from dual union all
142  select 'CS-4308851' as Product_Name,616 as Sold_Quantity,141 as Rank  from dual union all
143  select 'CS-4301193' as Product_Name,615 as Sold_Quantity,142 as Rank  from dual union all
144  select 'CS-8304125' as Product_Name,615 as Sold_Quantity,143 as Rank  from dual union all
145  select 'CS-6113715' as Product_Name,602 as Sold_Quantity,144 as Rank  from dual union all
146  select 'CS-5100137' as Product_Name,596 as Sold_Quantity,145 as Rank  from dual union all
147  select 'CS-4800021' as Product_Name,594 as Sold_Quantity,146 as Rank  from dual union all
148  select 'CS-5812156' as Product_Name,594 as Sold_Quantity,147 as Rank  from dual union all
149  select 'CS-3400787' as Product_Name,589 as Sold_Quantity,148 as Rank  from dual union all
150  select 'CS-9401400' as Product_Name,583 as Sold_Quantity,149 as Rank  from dual union all
151  select 'CS-3400789' as Product_Name,582 as Sold_Quantity,150 as Rank  from dual union all
152  select 'CS-6113716' as Product_Name,578 as Sold_Quantity,151 as Rank  from dual union all
153  select 'CS-4207007' as Product_Name,577 as Sold_Quantity,152 as Rank  from dual union all
154  select 'CS-6003309' as Product_Name,572 as Sold_Quantity,153 as Rank  from dual union all
155  select 'CS-6021320' as Product_Name,570 as Sold_Quantity,154 as Rank  from dual union all
156  select 'CS-4203816' as Product_Name,564 as Sold_Quantity,155 as Rank  from dual union all
157  select 'CS-6021315' as Product_Name,564 as Sold_Quantity,156 as Rank  from dual union all
158  select 'CS-3400779' as Product_Name,558 as Sold_Quantity,157 as Rank  from dual union all
159  select 'CS-6004982' as Product_Name,558 as Sold_Quantity,158 as Rank  from dual union all
160  select 'CS-4207021' as Product_Name,558 as Sold_Quantity,159 as Rank  from dual union all
161  select 'CS-3400798' as Product_Name,557 as Sold_Quantity,160 as Rank  from dual union all
162  select 'CS-4704772' as Product_Name,557 as Sold_Quantity,161 as Rank  from dual union all
163  select 'CS-6004983' as Product_Name,556 as Sold_Quantity,162 as Rank  from dual union all
164  select 'CS-6021323' as Product_Name,550 as Sold_Quantity,163 as Rank  from dual union all
165  select 'CS-6021311' as Product_Name,549 as Sold_Quantity,164 as Rank  from dual union all
166  select 'CS-1400004' as Product_Name,547 as Sold_Quantity,165 as Rank  from dual union all
167  select 'CS-3400775' as Product_Name,543 as Sold_Quantity,166 as Rank  from dual union all
168  select 'CS-3402149' as Product_Name,541 as Sold_Quantity,167 as Rank  from dual union all
169  select 'CS-6004987' as Product_Name,541 as Sold_Quantity,168 as Rank  from dual union all
170  select 'CS-3400776' as Product_Name,539 as Sold_Quantity,169 as Rank  from dual union all
171  select 'CS-6021314' as Product_Name,537 as Sold_Quantity,170 as Rank  from dual union all
172  select 'CS-3400774' as Product_Name,529 as Sold_Quantity,171 as Rank  from dual union all
173  select 'CS-6004984' as Product_Name,529 as Sold_Quantity,172 as Rank  from dual union all
174  select 'CS-4400291' as Product_Name,527 as Sold_Quantity,173 as Rank  from dual union all
175  select 'CS-6114551' as Product_Name,527 as Sold_Quantity,174 as Rank  from dual union all
176  select 'CS-6021332' as Product_Name,527 as Sold_Quantity,175 as Rank  from dual union all
177  select 'CS-3400777' as Product_Name,526 as Sold_Quantity,176 as Rank  from dual union all
178  select 'CS-6198203I' as Product_Name,526 as Sold_Quantity,177 as Rank  from dual union all
179  select 'CS-4407056' as Product_Name,526 as Sold_Quantity,178 as Rank  from dual union all
180  select 'CS-4207036' as Product_Name,523 as Sold_Quantity,179 as Rank  from dual union all
181  select 'CS-6021313' as Product_Name,523 as Sold_Quantity,180 as Rank  from dual union all
182  select 'CS-6021325' as Product_Name,521 as Sold_Quantity,181 as Rank  from dual union all
183  select 'CS-4601202' as Product_Name,517 as Sold_Quantity,182 as Rank  from dual union all
184  select 'CS-4400233' as Product_Name,515 as Sold_Quantity,183 as Rank  from dual union all
185  select 'CS-6004989' as Product_Name,514 as Sold_Quantity,184 as Rank  from dual union all
186  select 'CS-6113795' as Product_Name,514 as Sold_Quantity,185 as Rank  from dual union all
187  select 'CS-6006400' as Product_Name,514 as Sold_Quantity,186 as Rank  from dual union all
188  select 'CS-2000117' as Product_Name,512 as Sold_Quantity,187 as Rank  from dual union all
189  select 'CS-6021358' as Product_Name,512 as Sold_Quantity,188 as Rank  from dual union all
190  select 'CS-4101055' as Product_Name,511 as Sold_Quantity,189 as Rank  from dual union all
191  select 'CS-6004986' as Product_Name,509 as Sold_Quantity,190 as Rank  from dual union all
192  select 'CS-6006860' as Product_Name,509 as Sold_Quantity,191 as Rank  from dual union all
193  select 'CS-4400004' as Product_Name,507 as Sold_Quantity,192 as Rank  from dual union all
194  select 'CS-8400011' as Product_Name,507 as Sold_Quantity,193 as Rank  from dual union all
195  select 'CS-3001151' as Product_Name,505 as Sold_Quantity,194 as Rank  from dual union all
196  select 'CS-4209425' as Product_Name,502 as Sold_Quantity,195 as Rank  from dual union all
197  select 'CS-5102939' as Product_Name,498 as Sold_Quantity,196 as Rank  from dual union all
198  select 'CS-1500321' as Product_Name,494 as Sold_Quantity,197 as Rank  from dual union all
199  select 'CS-6111883' as Product_Name,493 as Sold_Quantity,198 as Rank  from dual union all
200  select 'CS-2470508Z' as Product_Name,491 as Sold_Quantity,199 as Rank  from dual union all
201  select 'CS-5861048' as Product_Name,489 as Sold_Quantity,200 as Rank  from dual union all
202  select 'CS-4700946' as Product_Name,486 as Sold_Quantity,201 as Rank  from dual union all
203  select 'CS-4400158' as Product_Name,481 as Sold_Quantity,202 as Rank  from dual union all
204  select 'CS-1500322' as Product_Name,476 as Sold_Quantity,203 as Rank  from dual union all
205  select 'CS-3400772' as Product_Name,468 as Sold_Quantity,204 as Rank  from dual union all
206  select 'CS-5109036' as Product_Name,462 as Sold_Quantity,205 as Rank  from dual union all
207  select 'CS-5812157' as Product_Name,462 as Sold_Quantity,206 as Rank  from dual union all
208  select 'CS-4806002' as Product_Name,460 as Sold_Quantity,207 as Rank  from dual union all
209  select 'CS-3400770' as Product_Name,458 as Sold_Quantity,208 as Rank  from dual union all
210  select 'CS-9408772' as Product_Name,458 as Sold_Quantity,209 as Rank  from dual union all
211  select 'CS-6004981' as Product_Name,456 as Sold_Quantity,210 as Rank  from dual union all
212  select 'CS-6021333' as Product_Name,456 as Sold_Quantity,211 as Rank  from dual union all
213  select 'CS-6000400' as Product_Name,453 as Sold_Quantity,212 as Rank  from dual union all
214  select 'CS-4203465' as Product_Name,451 as Sold_Quantity,213 as Rank  from dual union all
215  select 'CS-6021324' as Product_Name,448 as Sold_Quantity,214 as Rank  from dual union all
216  select 'CS-5101180' as Product_Name,446 as Sold_Quantity,215 as Rank  from dual union all
217  select 'CS-4400016' as Product_Name,444 as Sold_Quantity,216 as Rank  from dual union all
218  select 'CS-1509993' as Product_Name,442 as Sold_Quantity,217 as Rank  from dual union all
219  select 'CS-6111538' as Product_Name,442 as Sold_Quantity,218 as Rank  from dual union all
220  select 'CS-6021363' as Product_Name,440 as Sold_Quantity,219 as Rank  from dual union all
221  select 'CS-6111616' as Product_Name,440 as Sold_Quantity,220 as Rank  from dual union all
222  select 'CS-6021080' as Product_Name,439 as Sold_Quantity,221 as Rank  from dual union all
223  select 'CS-9200101' as Product_Name,439 as Sold_Quantity,222 as Rank  from dual union all
224  select 'CS-6111617' as Product_Name,439 as Sold_Quantity,223 as Rank  from dual union all
225  select 'CS-6112902' as Product_Name,432 as Sold_Quantity,224 as Rank  from dual union all
226  select 'CS-4400292' as Product_Name,427 as Sold_Quantity,225 as Rank  from dual union all
227  select 'CS-9200553' as Product_Name,426 as Sold_Quantity,226 as Rank  from dual union all
228  select 'CS-6193150I' as Product_Name,424 as Sold_Quantity,227 as Rank  from dual union all
229  select 'CS-3001150' as Product_Name,422 as Sold_Quantity,228 as Rank  from dual union all
230  select 'CS-4400095' as Product_Name,421 as Sold_Quantity,229 as Rank  from dual union all
231  select 'CS-4100028' as Product_Name,420 as Sold_Quantity,230 as Rank  from dual union all
232  select 'CS-5101237' as Product_Name,420 as Sold_Quantity,231 as Rank  from dual union all
233  select 'CS-4100029' as Product_Name,418 as Sold_Quantity,232 as Rank  from dual union all
234  select 'CS-4203819' as Product_Name,417 as Sold_Quantity,233 as Rank  from dual union all
235  select 'CS-6021316' as Product_Name,417 as Sold_Quantity,234 as Rank  from dual union all
236  select 'CS-4203814' as Product_Name,416 as Sold_Quantity,235 as Rank  from dual union all
237  select 'CS-3400771' as Product_Name,410 as Sold_Quantity,236 as Rank  from dual union all
238  select 'CS-4207034' as Product_Name,410 as Sold_Quantity,237 as Rank  from dual union all
239  select 'CS-3402146' as Product_Name,408 as Sold_Quantity,238 as Rank  from dual union all
240  select 'CS-6005948' as Product_Name,408 as Sold_Quantity,239 as Rank  from dual union all
241  select 'CS-6022054' as Product_Name,406 as Sold_Quantity,240 as Rank  from dual union all
242  select 'CS-6113251' as Product_Name,403 as Sold_Quantity,241 as Rank  from dual union all
243  select 'CS-2470360' as Product_Name,402 as Sold_Quantity,242 as Rank  from dual union all
244  select 'CS-6007131' as Product_Name,402 as Sold_Quantity,243 as Rank  from dual union all
245  select 'CS-6113694' as Product_Name,399 as Sold_Quantity,244 as Rank  from dual union all
246  select 'CS-6111664' as Product_Name,396 as Sold_Quantity,245 as Rank  from dual union all
247  select 'CS-3400320' as Product_Name,395 as Sold_Quantity,246 as Rank  from dual union all
248  select 'CS-9301013' as Product_Name,395 as Sold_Quantity,247 as Rank  from dual union all
249  select 'CS-3400786' as Product_Name,393 as Sold_Quantity,248 as Rank  from dual union all
250  select 'CS-4400367' as Product_Name,393 as Sold_Quantity,249 as Rank  from dual union all
251  select 'CS-6021359' as Product_Name,391 as Sold_Quantity,250 as Rank  from dual union all
252  select 'CS-9207400' as Product_Name,391 as Sold_Quantity,251 as Rank  from dual union all
253  select 'CS-6110292' as Product_Name,391 as Sold_Quantity,252 as Rank  from dual union all
254  select 'CS-4400501' as Product_Name,387 as Sold_Quantity,253 as Rank  from dual union all
255  select 'CS-5201255' as Product_Name,385 as Sold_Quantity,254 as Rank  from dual union all
256  select 'CS-4400057' as Product_Name,383 as Sold_Quantity,255 as Rank  from dual union all
257  select 'CS-3009915' as Product_Name,380 as Sold_Quantity,256 as Rank  from dual union all
258  select 'CS-6001354' as Product_Name,376 as Sold_Quantity,257 as Rank  from dual union all
259  select 'CS-4400500' as Product_Name,374 as Sold_Quantity,258 as Rank  from dual union all
260  select 'CS-4606648' as Product_Name,374 as Sold_Quantity,259 as Rank  from dual union all
261  select 'CS-4209503' as Product_Name,371 as Sold_Quantity,260 as Rank  from dual union all
262  select 'CS-6002053' as Product_Name,371 as Sold_Quantity,261 as Rank  from dual union all
263  select 'CS-3007869' as Product_Name,369 as Sold_Quantity,262 as Rank  from dual union all
264  select 'CS-3402143' as Product_Name,367 as Sold_Quantity,263 as Rank  from dual union all
265  select 'CS-4406340' as Product_Name,367 as Sold_Quantity,264 as Rank  from dual union all
266  select 'CS-2470498' as Product_Name,366 as Sold_Quantity,265 as Rank  from dual union all
267  select 'CS-7201101' as Product_Name,366 as Sold_Quantity,266 as Rank  from dual union all
268  select 'CS-3001176' as Product_Name,365 as Sold_Quantity,267 as Rank  from dual union all
269  select 'CS-6007130' as Product_Name,363 as Sold_Quantity,268 as Rank  from dual union all
270  select 'CS-6021364' as Product_Name,363 as Sold_Quantity,269 as Rank  from dual union all
271  select 'CS-3201150' as Product_Name,362 as Sold_Quantity,270 as Rank  from dual union all
272  select 'CS-4400364' as Product_Name,362 as Sold_Quantity,271 as Rank  from dual union all
273  select 'CS-5100224' as Product_Name,361 as Sold_Quantity,272 as Rank  from dual union all
274  select 'CS-6004990' as Product_Name,361 as Sold_Quantity,273 as Rank  from dual union all
275  select 'CS-6021295' as Product_Name,360 as Sold_Quantity,274 as Rank  from dual union all
276  select 'CS-9200417' as Product_Name,360 as Sold_Quantity,275 as Rank  from dual union all
277  select 'CS-6021014' as Product_Name,358 as Sold_Quantity,276 as Rank  from dual union all
278  select 'CS-4301145' as Product_Name,357 as Sold_Quantity,277 as Rank  from dual union all
279  select 'CS-6004991' as Product_Name,357 as Sold_Quantity,278 as Rank  from dual union all
280  select 'CS-4400022' as Product_Name,357 as Sold_Quantity,279 as Rank  from dual union all
281  select 'CS-3010211' as Product_Name,356 as Sold_Quantity,280 as Rank  from dual union all
282  select 'CS-6006864' as Product_Name,356 as Sold_Quantity,281 as Rank  from dual union all
283  select 'CS-4301195' as Product_Name,353 as Sold_Quantity,282 as Rank  from dual union all
284  select 'CS-6005196' as Product_Name,352 as Sold_Quantity,283 as Rank  from dual union all
285  select 'CS-5100297' as Product_Name,350 as Sold_Quantity,284 as Rank  from dual union all
286  select 'CS-6003916' as Product_Name,347 as Sold_Quantity,285 as Rank  from dual union all
287  select 'CS-9304860' as Product_Name,347 as Sold_Quantity,286 as Rank  from dual union all
288  select 'CS-3401666' as Product_Name,345 as Sold_Quantity,287 as Rank  from dual union all
289  select 'CS-4401257' as Product_Name,341 as Sold_Quantity,288 as Rank  from dual union all
290  select 'CS-6006035' as Product_Name,339 as Sold_Quantity,289 as Rank  from dual union all
291  select 'CS-6193656' as Product_Name,336 as Sold_Quantity,290 as Rank  from dual union all
292  select 'CS-4700948' as Product_Name,335 as Sold_Quantity,291 as Rank  from dual union all
293  select 'CS-6021292' as Product_Name,334 as Sold_Quantity,292 as Rank  from dual union all
294  select 'CS-5100227' as Product_Name,333 as Sold_Quantity,293 as Rank  from dual union all
295  select 'CS-4400055' as Product_Name,332 as Sold_Quantity,294 as Rank  from dual union all
296  select 'CS-8400846' as Product_Name,332 as Sold_Quantity,295 as Rank  from dual union all
297  select 'CS-8401165' as Product_Name,331 as Sold_Quantity,296 as Rank  from dual union all
298  select 'CS-3001148' as Product_Name,330 as Sold_Quantity,297 as Rank  from dual union all
299  select 'CS-5816892' as Product_Name,329 as Sold_Quantity,298 as Rank  from dual union all
300  select 'CS-6021491' as Product_Name,328 as Sold_Quantity,299 as Rank  from dual union all
301  select 'CS-3201149' as Product_Name,326 as Sold_Quantity,300 as Rank  from dual union all
302  select 'CS-6005338' as Product_Name,326 as Sold_Quantity,301 as Rank  from dual union all
303  select 'CS-3400130' as Product_Name,325 as Sold_Quantity,302 as Rank  from dual union all
304  select 'CS-6021365' as Product_Name,325 as Sold_Quantity,303 as Rank  from dual union all
305  select 'CS-4100075' as Product_Name,324 as Sold_Quantity,304 as Rank  from dual union all
306  select 'CS-2401287' as Product_Name,322 as Sold_Quantity,305 as Rank  from dual union all
307  select 'CS-4405378' as Product_Name,319 as Sold_Quantity,306 as Rank  from dual union all
308  select 'CS-6004993' as Product_Name,319 as Sold_Quantity,307 as Rank  from dual union all
309  select 'CS-4400290' as Product_Name,317 as Sold_Quantity,308 as Rank  from dual union all
310  select 'CS-6005909' as Product_Name,314 as Sold_Quantity,309 as Rank  from dual union all
311  select 'CS-6021317' as Product_Name,314 as Sold_Quantity,310 as Rank  from dual union all
312  select 'CS-3200610' as Product_Name,313 as Sold_Quantity,311 as Rank  from dual union all
313  select 'CS-3011520' as Product_Name,312 as Sold_Quantity,312 as Rank  from dual union all
314  select 'CS-6192005' as Product_Name,312 as Sold_Quantity,313 as Rank  from dual union all
315  select 'CS-6005195' as Product_Name,312 as Sold_Quantity,314 as Rank  from dual union all
316  select 'CS-4400147' as Product_Name,312 as Sold_Quantity,315 as Rank  from dual union all
317  select 'CS-6021372' as Product_Name,311 as Sold_Quantity,316 as Rank  from dual union all
318  select 'CS-6007004' as Product_Name,310 as Sold_Quantity,317 as Rank  from dual union all
319  select 'CS-4202289' as Product_Name,307 as Sold_Quantity,318 as Rank  from dual union all
320  select 'CS-6021326' as Product_Name,306 as Sold_Quantity,319 as Rank  from dual union all
321  select 'CS-4801402' as Product_Name,305 as Sold_Quantity,320 as Rank  from dual union all
322  select 'CS-4207012' as Product_Name,304 as Sold_Quantity,321 as Rank  from dual union all
323  select 'CS-6002052' as Product_Name,302 as Sold_Quantity,322 as Rank  from dual union all
324  select 'CS-9200385' as Product_Name,302 as Sold_Quantity,323 as Rank  from dual union all
325  select 'CS-6021494' as Product_Name,302 as Sold_Quantity,324 as Rank  from dual union all
326  select 'CS-2402087' as Product_Name,301 as Sold_Quantity,325 as Rank  from dual union all
327  select 'CS-6006884' as Product_Name,301 as Sold_Quantity,326 as Rank  from dual union all
328  select 'CS-5105854' as Product_Name,300 as Sold_Quantity,327 as Rank  from dual union all
329  select 'CS-5101066' as Product_Name,299 as Sold_Quantity,328 as Rank  from dual union all
330  select 'CS-6116600' as Product_Name,299 as Sold_Quantity,329 as Rank  from dual union all
331  select 'CS-6007003' as Product_Name,299 as Sold_Quantity,330 as Rank  from dual union all
332  select 'CS-6005950' as Product_Name,299 as Sold_Quantity,331 as Rank  from dual union all
333  select 'CS-6004992' as Product_Name,298 as Sold_Quantity,332 as Rank  from dual union all
334  select 'CS-6111388Z' as Product_Name,298 as Sold_Quantity,333 as Rank  from dual union all
335  select 'CS-6001201' as Product_Name,297 as Sold_Quantity,334 as Rank  from dual union all
336  select 'CS-6002340' as Product_Name,295 as Sold_Quantity,335 as Rank  from dual union all
337  select 'CS-3402187' as Product_Name,294 as Sold_Quantity,336 as Rank  from dual union all
338  select 'CS-9202445' as Product_Name,294 as Sold_Quantity,337 as Rank  from dual union all
339  select 'CS-1400312' as Product_Name,293 as Sold_Quantity,338 as Rank  from dual union all
340  select 'CS-3400773' as Product_Name,293 as Sold_Quantity,339 as Rank  from dual union all
341  select 'CS-5860417' as Product_Name,291 as Sold_Quantity,340 as Rank  from dual union all
342  select 'CS-6111004' as Product_Name,291 as Sold_Quantity,341 as Rank  from dual union all
343  select 'CS-5109106' as Product_Name,290 as Sold_Quantity,342 as Rank  from dual union all
344  select 'CS-3400782' as Product_Name,289 as Sold_Quantity,343 as Rank  from dual union all
345  select 'CS-6022053' as Product_Name,288 as Sold_Quantity,344 as Rank  from dual union all
346  select 'CS-4606649' as Product_Name,287 as Sold_Quantity,345 as Rank  from dual union all
347  select 'CS-6021318' as Product_Name,287 as Sold_Quantity,346 as Rank  from dual union all
348  select 'CS-2002485' as Product_Name,286 as Sold_Quantity,347 as Rank  from dual union all
349  select 'CS-3008983' as Product_Name,285 as Sold_Quantity,348 as Rank  from dual union all
350  select 'CS-3200611' as Product_Name,283 as Sold_Quantity,349 as Rank  from dual union all
351  select 'CS-6005366' as Product_Name,283 as Sold_Quantity,350 as Rank  from dual union all
352  select 'CS-3011519' as Product_Name,282 as Sold_Quantity,351 as Rank  from dual union all
353  select 'CS-6006882' as Product_Name,282 as Sold_Quantity,352 as Rank  from dual union all
354  select 'CS-2000525' as Product_Name,281 as Sold_Quantity,353 as Rank  from dual union all
355  select 'CS-6021493' as Product_Name,281 as Sold_Quantity,354 as Rank  from dual union all
356  select 'CS-4203813' as Product_Name,280 as Sold_Quantity,355 as Rank  from dual union all
357  select 'CS-6021490' as Product_Name,280 as Sold_Quantity,356 as Rank  from dual union all
358  select 'CS-4207043' as Product_Name,279 as Sold_Quantity,357 as Rank  from dual union all
359  select 'CS-6113853' as Product_Name,279 as Sold_Quantity,358 as Rank  from dual union all
360  select 'CS-4400370' as Product_Name,277 as Sold_Quantity,359 as Rank  from dual union all
361  select 'CS-6190468' as Product_Name,277 as Sold_Quantity,360 as Rank  from dual union all
362  select 'CS-4300878' as Product_Name,275 as Sold_Quantity,361 as Rank  from dual union all
363  select 'CS-6004980' as Product_Name,275 as Sold_Quantity,362 as Rank  from dual union all
364  select 'CS-5102766' as Product_Name,275 as Sold_Quantity,363 as Rank  from dual union all
365  select 'CS-6005474' as Product_Name,274 as Sold_Quantity,364 as Rank  from dual union all
366  select 'CS-4400056' as Product_Name,272 as Sold_Quantity,365 as Rank  from dual union all
367  select 'CS-6190009' as Product_Name,272 as Sold_Quantity,366 as Rank  from dual union all
368  select 'CS-6004988' as Product_Name,272 as Sold_Quantity,367 as Rank  from dual union all
369  select 'CS-5100109' as Product_Name,272 as Sold_Quantity,368 as Rank  from dual union all
370  select 'CS-3011521' as Product_Name,271 as Sold_Quantity,369 as Rank  from dual union all
371  select 'CS-3001607' as Product_Name,270 as Sold_Quantity,370 as Rank  from dual union all
372  select 'CS-4800055' as Product_Name,270 as Sold_Quantity,371 as Rank  from dual union all
373  select 'CS-6021492' as Product_Name,269 as Sold_Quantity,372 as Rank  from dual union all
374  select 'CS-2000119' as Product_Name,268 as Sold_Quantity,373 as Rank  from dual union all
375  select 'CS-5208998' as Product_Name,268 as Sold_Quantity,374 as Rank  from dual union all
376  select 'CS-5100304' as Product_Name,268 as Sold_Quantity,375 as Rank  from dual union all
377  select 'CS-3401658' as Product_Name,266 as Sold_Quantity,376 as Rank  from dual union all
378  select 'CS-3402177' as Product_Name,266 as Sold_Quantity,377 as Rank  from dual union all
379  select 'CS-3402179' as Product_Name,265 as Sold_Quantity,378 as Rank  from dual union all
380  select 'CS-6021319' as Product_Name,265 as Sold_Quantity,379 as Rank  from dual union all
381  select 'CS-3004607' as Product_Name,264 as Sold_Quantity,380 as Rank  from dual union all
382  select 'CS-5070003' as Product_Name,263 as Sold_Quantity,381 as Rank  from dual union all
383  select 'CS-6193151' as Product_Name,263 as Sold_Quantity,382 as Rank  from dual union all
384  select 'CS-3001603' as Product_Name,262 as Sold_Quantity,383 as Rank  from dual union all
385  select 'CS-8305066' as Product_Name,262 as Sold_Quantity,384 as Rank  from dual union all
386  select 'CS-3402167' as Product_Name,261 as Sold_Quantity,385 as Rank  from dual union all
387  select 'CS-5100153' as Product_Name,261 as Sold_Quantity,386 as Rank  from dual union all
388  select 'CS-3402185' as Product_Name,261 as Sold_Quantity,387 as Rank  from dual union all
389  select 'CS-9101013' as Product_Name,260 as Sold_Quantity,388 as Rank  from dual union all
390  select 'CS-5860418' as Product_Name,259 as Sold_Quantity,389 as Rank  from dual union all
391  select 'CS-4400232' as Product_Name,257 as Sold_Quantity,390 as Rank  from dual union all
392  select 'CS-6004995' as Product_Name,257 as Sold_Quantity,391 as Rank  from dual union all
393  select 'CS-5100192' as Product_Name,257 as Sold_Quantity,392 as Rank  from dual union all
394  select 'CS-2002488' as Product_Name,256 as Sold_Quantity,393 as Rank  from dual union all
395  select 'CS-9402099' as Product_Name,256 as Sold_Quantity,394 as Rank  from dual union all
396  select 'CS-6021327' as Product_Name,256 as Sold_Quantity,395 as Rank  from dual union all
397  select 'CS-2470137' as Product_Name,256 as Sold_Quantity,396 as Rank  from dual union all
398  select 'CS-3001600' as Product_Name,254 as Sold_Quantity,397 as Rank  from dual union all
399  select 'CS-9203169' as Product_Name,254 as Sold_Quantity,398 as Rank  from dual union all
400  select 'CS-5901043' as Product_Name,254 as Sold_Quantity,399 as Rank  from dual union all
401  select 'CS-4102599' as Product_Name,254 as Sold_Quantity,400 as Rank  from dual union all
402  select 'CS-4100069' as Product_Name,253 as Sold_Quantity,401 as Rank  from dual union all
403  select 'CS-6003320' as Product_Name,253 as Sold_Quantity,402 as Rank  from dual union all
404  select 'CS-3402165' as Product_Name,251 as Sold_Quantity,403 as Rank  from dual union all
405  select 'CS-6003904' as Product_Name,251 as Sold_Quantity,404 as Rank  from dual union all
406  select 'CS-4400229' as Product_Name,250 as Sold_Quantity,405 as Rank  from dual union all
407  select 'CS-6005949' as Product_Name,250 as Sold_Quantity,406 as Rank  from dual union all
408  select 'CS-1501021' as Product_Name,249 as Sold_Quantity,407 as Rank  from dual union all
409  select 'CS-8301009' as Product_Name,249 as Sold_Quantity,408 as Rank  from dual union all
410  select 'CS-5811214I' as Product_Name,249 as Sold_Quantity,409 as Rank  from dual union all
411  select 'CS-3009585' as Product_Name,249 as Sold_Quantity,410 as Rank  from dual union all
412  select 'CS-3203277' as Product_Name,247 as Sold_Quantity,411 as Rank  from dual union all
413  select 'CS-3401657' as Product_Name,247 as Sold_Quantity,412 as Rank  from dual union all
414  select 'CS-3008976' as Product_Name,246 as Sold_Quantity,413 as Rank  from dual union all
415  select 'CS-9201321' as Product_Name,246 as Sold_Quantity,414 as Rank  from dual union all
416  select 'CS-6191082' as Product_Name,246 as Sold_Quantity,415 as Rank  from dual union all
417  select 'CS-3400792' as Product_Name,244 as Sold_Quantity,416 as Rank  from dual union all
418  select 'CS-4709900' as Product_Name,244 as Sold_Quantity,417 as Rank  from dual union all
419  select 'CS-2400318' as Product_Name,243 as Sold_Quantity,418 as Rank  from dual union all
420  select 'CS-9203002' as Product_Name,243 as Sold_Quantity,419 as Rank  from dual union all
421  select 'CS-9202840' as Product_Name,243 as Sold_Quantity,420 as Rank  from dual union all
422  select 'CS-3005224' as Product_Name,243 as Sold_Quantity,421 as Rank  from dual union all
423  select 'CS-3402171' as Product_Name,242 as Sold_Quantity,422 as Rank  from dual union all
424  select 'CS-6191087' as Product_Name,242 as Sold_Quantity,423 as Rank  from dual union all
425  select 'CS-6110326' as Product_Name,242 as Sold_Quantity,424 as Rank  from dual union all
426  select 'CS-6002341' as Product_Name,242 as Sold_Quantity,425 as Rank  from dual union all
427  select 'CS-6005194' as Product_Name,241 as Sold_Quantity,426 as Rank  from dual union all
428  select 'CS-6005951' as Product_Name,241 as Sold_Quantity,427 as Rank  from dual union all
429  select 'CS-1505165' as Product_Name,240 as Sold_Quantity,428 as Rank  from dual union all
430  select 'CS-6006037' as Product_Name,240 as Sold_Quantity,429 as Rank  from dual union all
431  select 'CS-3009583' as Product_Name,239 as Sold_Quantity,430 as Rank  from dual union all
432  select 'CS-4701023' as Product_Name,239 as Sold_Quantity,431 as Rank  from dual union all
433  select 'CS-4200188' as Product_Name,239 as Sold_Quantity,432 as Rank  from dual union all
434  select 'CS-3402181' as Product_Name,239 as Sold_Quantity,433 as Rank  from dual union all
435  select 'CS-3401659' as Product_Name,238 as Sold_Quantity,434 as Rank  from dual union all
436  select 'CS-3402163' as Product_Name,238 as Sold_Quantity,435 as Rank  from dual union all
437  select 'CS-3001157' as Product_Name,237 as Sold_Quantity,436 as Rank  from dual union all
438  select 'CS-6005947' as Product_Name,237 as Sold_Quantity,437 as Rank  from dual union all
439  select 'CS-5101038' as Product_Name,237 as Sold_Quantity,438 as Rank  from dual union all
440  select 'CS-6004979' as Product_Name,236 as Sold_Quantity,439 as Rank  from dual union all
441  select 'CS-9202240' as Product_Name,236 as Sold_Quantity,440 as Rank  from dual union all
442  select 'CS-6021054' as Product_Name,235 as Sold_Quantity,441 as Rank  from dual union all
443  select 'CS-6021495' as Product_Name,235 as Sold_Quantity,442 as Rank  from dual union all
444  select 'CS-3009588' as Product_Name,234 as Sold_Quantity,443 as Rank  from dual union all
445  select 'CS-6112436' as Product_Name,234 as Sold_Quantity,444 as Rank  from dual union all
446  select 'CS-5201549' as Product_Name,234 as Sold_Quantity,445 as Rank  from dual union all
447  select 'CS-2470600' as Product_Name,233 as Sold_Quantity,446 as Rank  from dual union all
448  select 'CS-8300085' as Product_Name,233 as Sold_Quantity,447 as Rank  from dual union all
449  select 'CS-5201089' as Product_Name,233 as Sold_Quantity,448 as Rank  from dual union all
450  select 'CS-5104815' as Product_Name,233 as Sold_Quantity,449 as Rank  from dual union all
451  select 'CS-1304432' as Product_Name,232 as Sold_Quantity,450 as Rank  from dual union all
452  select 'CS-6112823' as Product_Name,232 as Sold_Quantity,451 as Rank  from dual union all
453  select 'CS-6005952' as Product_Name,232 as Sold_Quantity,452 as Rank  from dual union all
454  select 'CS-6004003' as Product_Name,232 as Sold_Quantity,453 as Rank  from dual union all
455  select 'CS-4209427' as Product_Name,232 as Sold_Quantity,454 as Rank  from dual union all
456  select 'CS-3009582' as Product_Name,231 as Sold_Quantity,455 as Rank  from dual union all
457  select 'CS-8300126' as Product_Name,231 as Sold_Quantity,456 as Rank  from dual union all
458  select 'CS-5105904' as Product_Name,231 as Sold_Quantity,457 as Rank  from dual union all
459  select 'CS-3401656' as Product_Name,230 as Sold_Quantity,458 as Rank  from dual union all
460  select 'CS-9200539' as Product_Name,230 as Sold_Quantity,459 as Rank  from dual union all
461  select 'CS-3402183' as Product_Name,230 as Sold_Quantity,460 as Rank  from dual union all
462  select 'CS-5050023L' as Product_Name,228 as Sold_Quantity,461 as Rank  from dual union all
463  select 'CS-9200323' as Product_Name,228 as Sold_Quantity,462 as Rank  from dual union all
464  select 'CS-3008970' as Product_Name,227 as Sold_Quantity,463 as Rank  from dual union all
465  select 'CS-3402169' as Product_Name,227 as Sold_Quantity,464 as Rank  from dual union all
466  select 'CS-3008994' as Product_Name,227 as Sold_Quantity,465 as Rank  from dual union all
467  select 'CS-4900425' as Product_Name,226 as Sold_Quantity,466 as Rank  from dual union all
468  select 'CS-6194436' as Product_Name,226 as Sold_Quantity,467 as Rank  from dual union all
469  select 'CS-6006036' as Product_Name,226 as Sold_Quantity,468 as Rank  from dual union all
470  select 'CS-3008978' as Product_Name,225 as Sold_Quantity,469 as Rank  from dual union all
471  select 'CS-3401664' as Product_Name,225 as Sold_Quantity,470 as Rank  from dual union all
472  select 'CS-3008985' as Product_Name,224 as Sold_Quantity,471 as Rank  from dual union all
473  select 'CS-4400297' as Product_Name,223 as Sold_Quantity,472 as Rank  from dual union all
474  select 'CS-1401277' as Product_Name,222 as Sold_Quantity,473 as Rank  from dual union all
475  select 'CS-3008973' as Product_Name,222 as Sold_Quantity,474 as Rank  from dual union all
476  select 'CS-3008987' as Product_Name,221 as Sold_Quantity,475 as Rank  from dual union all
477  select 'CS-6194980' as Product_Name,220 as Sold_Quantity,476 as Rank  from dual union all
478  select 'CS-3008971' as Product_Name,219 as Sold_Quantity,477 as Rank  from dual union all
479  select 'CS-6193147' as Product_Name,219 as Sold_Quantity,478 as Rank  from dual union all
480  select 'CS-6006401' as Product_Name,219 as Sold_Quantity,479 as Rank  from dual union all
481  select 'CS-4100251' as Product_Name,219 as Sold_Quantity,480 as Rank  from dual union all
482  select 'CS-3008975' as Product_Name,218 as Sold_Quantity,481 as Rank  from dual union all
483  select 'CS-6009850' as Product_Name,218 as Sold_Quantity,482 as Rank  from dual union all
484  select 'CS-6006863' as Product_Name,218 as Sold_Quantity,483 as Rank  from dual union all
485  select 'CS-3008974' as Product_Name,217 as Sold_Quantity,484 as Rank  from dual union all
486  select 'CS-4304964' as Product_Name,216 as Sold_Quantity,485 as Rank  from dual union all
487  select 'CS-8302439' as Product_Name,216 as Sold_Quantity,486 as Rank  from dual union all
488  select 'CS-6006413' as Product_Name,216 as Sold_Quantity,487 as Rank  from dual union all
489  select 'CS-4209420' as Product_Name,215 as Sold_Quantity,488 as Rank  from dual union all
490  select 'CS-7201086' as Product_Name,215 as Sold_Quantity,489 as Rank  from dual union all
491  select 'CS-3008972' as Product_Name,214 as Sold_Quantity,490 as Rank  from dual union all
492  select 'CS-5201254' as Product_Name,214 as Sold_Quantity,491 as Rank  from dual union all
493  select 'CS-4207038' as Product_Name,214 as Sold_Quantity,492 as Rank  from dual union all
494  select 'CS-3401665' as Product_Name,214 as Sold_Quantity,493 as Rank  from dual union all
495  select 'CS-3402145' as Product_Name,213 as Sold_Quantity,494 as Rank  from dual union all
496  select 'CS-9101028' as Product_Name,213 as Sold_Quantity,495 as Rank  from dual union all
497  select 'CS-3008977' as Product_Name,212 as Sold_Quantity,496 as Rank  from dual union all
498  select 'CS-7203300' as Product_Name,212 as Sold_Quantity,497 as Rank  from dual union all
499  select 'CS-3401655' as Product_Name,211 as Sold_Quantity,498 as Rank  from dual union all
500  select 'CS-5072036' as Product_Name,211 as Sold_Quantity,499 as Rank  from dual union all
501  select 'CS-4400296' as Product_Name,211 as Sold_Quantity,500 as Rank  from dual union all
502  select 'CS-3401653' as Product_Name,210 as Sold_Quantity,501 as Rank  from dual union all
503  select 'CS-6006415' as Product_Name,210 as Sold_Quantity,502 as Rank  from dual union all
504  select 'CS-9200352' as Product_Name,209 as Sold_Quantity,503 as Rank  from dual union all
505  select 'CS-3001602' as Product_Name,208 as Sold_Quantity,504 as Rank  from dual union all
506  select 'CS-6190004' as Product_Name,208 as Sold_Quantity,505 as Rank  from dual union all
507  select 'CS-5811117' as Product_Name,208 as Sold_Quantity,506 as Rank  from dual union all
508  select 'CS-4405530' as Product_Name,208 as Sold_Quantity,507 as Rank  from dual union all
509  select 'CS-3008992' as Product_Name,208 as Sold_Quantity,508 as Rank  from dual union all
510  select 'CS-3008991' as Product_Name,208 as Sold_Quantity,509 as Rank  from dual union all
511  select 'CS-5861041' as Product_Name,206 as Sold_Quantity,510 as Rank  from dual union all
512  select 'CS-4309820' as Product_Name,205 as Sold_Quantity,511 as Rank  from dual union all
513  select 'CS-5861005' as Product_Name,205 as Sold_Quantity,512 as Rank  from dual union all
514  select 'CS-5106805' as Product_Name,205 as Sold_Quantity,513 as Rank  from dual union all
515  select 'CS-6004994' as Product_Name,203 as Sold_Quantity,514 as Rank  from dual union all
516  select 'CS-6193112' as Product_Name,203 as Sold_Quantity,515 as Rank  from dual union all
517  select 'CS-5101018' as Product_Name,202 as Sold_Quantity,516 as Rank  from dual union all
518  select 'CS-5103356' as Product_Name,202 as Sold_Quantity,517 as Rank  from dual union all
519  select 'CS-6002712' as Product_Name,201 as Sold_Quantity,518 as Rank  from dual union all
520  select 'CS-4700950' as Product_Name,200 as Sold_Quantity,519 as Rank  from dual union all
521  select 'CS-6191262' as Product_Name,200 as Sold_Quantity,520 as Rank  from dual union all
522  select 'CS-6006038' as Product_Name,200 as Sold_Quantity,521 as Rank  from dual union all
523  select 'CS-6005953' as Product_Name,200 as Sold_Quantity,522 as Rank  from dual union all
524  select 'CS-6000641' as Product_Name,200 as Sold_Quantity,523 as Rank  from dual union all
525  select 'CS-5107629' as Product_Name,200 as Sold_Quantity,524 as Rank  from dual union all
526  select 'CS-5050026' as Product_Name,200 as Sold_Quantity,525 as Rank  from dual union all
527  select 'CS-3001604' as Product_Name,199 as Sold_Quantity,526 as Rank  from dual union all
528  select 'CS-8300240' as Product_Name,199 as Sold_Quantity,527 as Rank  from dual union all
529  select 'CS-6005188' as Product_Name,199 as Sold_Quantity,528 as Rank  from dual union all
530  select 'CS-5102938' as Product_Name,199 as Sold_Quantity,529 as Rank  from dual union all
531  select 'CS-3008980' as Product_Name,199 as Sold_Quantity,530 as Rank  from dual union all
532  select 'CS-3001695' as Product_Name,198 as Sold_Quantity,531 as Rank  from dual union all
533  select 'CS-6110492' as Product_Name,198 as Sold_Quantity,532 as Rank  from dual union all
534  select 'CS-5107764' as Product_Name,198 as Sold_Quantity,533 as Rank  from dual union all
535  select 'CS-5862500' as Product_Name,197 as Sold_Quantity,534 as Rank  from dual union all
536  select 'CS-9202400' as Product_Name,197 as Sold_Quantity,535 as Rank  from dual union all
537  select 'CS-3008989' as Product_Name,196 as Sold_Quantity,536 as Rank  from dual union all
538  select 'CS-4400156' as Product_Name,196 as Sold_Quantity,537 as Rank  from dual union all
539  select 'CS-2401290' as Product_Name,195 as Sold_Quantity,538 as Rank  from dual union all
540  select 'CS-3009460' as Product_Name,194 as Sold_Quantity,539 as Rank  from dual union all
541  select 'CS-4800024' as Product_Name,194 as Sold_Quantity,540 as Rank  from dual union all
542  select 'CS-3401663' as Product_Name,194 as Sold_Quantity,541 as Rank  from dual union all
543  select 'CS-9300126' as Product_Name,193 as Sold_Quantity,542 as Rank  from dual union all
544  select 'CS-5050006' as Product_Name,192 as Sold_Quantity,543 as Rank  from dual union all
545  select 'CS-9306506' as Product_Name,192 as Sold_Quantity,544 as Rank  from dual union all
546  select 'CS-8302011' as Product_Name,192 as Sold_Quantity,545 as Rank  from dual union all
547  select 'CS-6021369' as Product_Name,192 as Sold_Quantity,546 as Rank  from dual union all
548  select 'CS-6021047' as Product_Name,192 as Sold_Quantity,547 as Rank  from dual union all
549  select 'CS-6002784' as Product_Name,192 as Sold_Quantity,548 as Rank  from dual union all
550  select 'CS-5100169' as Product_Name,192 as Sold_Quantity,549 as Rank  from dual union all
551  select 'CS-3008979' as Product_Name,191 as Sold_Quantity,550 as Rank  from dual union all
552  select 'CS-6164322' as Product_Name,191 as Sold_Quantity,551 as Rank  from dual union all
553  select 'CS-2002482' as Product_Name,190 as Sold_Quantity,552 as Rank  from dual union all
554  select 'CS-3001155' as Product_Name,189 as Sold_Quantity,553 as Rank  from dual union all
555  select 'CS-6113798' as Product_Name,189 as Sold_Quantity,554 as Rank  from dual union all
556  select 'CS-3200612' as Product_Name,187 as Sold_Quantity,555 as Rank  from dual union all
557  select 'CS-9203995' as Product_Name,187 as Sold_Quantity,556 as Rank  from dual union all
558  select 'CS-4402925' as Product_Name,187 as Sold_Quantity,557 as Rank  from dual union all
559  select 'CS-4400121' as Product_Name,186 as Sold_Quantity,558 as Rank  from dual union all
560  select 'CS-9208015' as Product_Name,186 as Sold_Quantity,559 as Rank  from dual union all
561  select 'CS-8400580' as Product_Name,186 as Sold_Quantity,560 as Rank  from dual union all
562  select 'CS-3008993' as Product_Name,185 as Sold_Quantity,561 as Rank  from dual union all
563  select 'CS-9300030' as Product_Name,185 as Sold_Quantity,562 as Rank  from dual union all
564  select 'CS-3402147' as Product_Name,185 as Sold_Quantity,563 as Rank  from dual union all
565  select 'CS-3009576' as Product_Name,185 as Sold_Quantity,564 as Rank  from dual union all
566  select 'CS-3009572' as Product_Name,185 as Sold_Quantity,565 as Rank  from dual union all
567  select 'CS-3001152' as Product_Name,184 as Sold_Quantity,566 as Rank  from dual union all
568  select 'CS-9202131' as Product_Name,184 as Sold_Quantity,567 as Rank  from dual union all
569  select 'CS-6021477' as Product_Name,184 as Sold_Quantity,568 as Rank  from dual union all
570  select 'CS-5101322' as Product_Name,183 as Sold_Quantity,569 as Rank  from dual union all
571  select 'CS-3011518' as Product_Name,182 as Sold_Quantity,570 as Rank  from dual union all
572  select 'CS-6191232' as Product_Name,182 as Sold_Quantity,571 as Rank  from dual union all
573  select 'CS-6003353' as Product_Name,182 as Sold_Quantity,572 as Rank  from dual union all
574  select 'CS-3008982' as Product_Name,181 as Sold_Quantity,573 as Rank  from dual union all
575  select 'CS-6004019' as Product_Name,181 as Sold_Quantity,574 as Rank  from dual union all
576  select 'CS-3008968' as Product_Name,180 as Sold_Quantity,575 as Rank  from dual union all
577  select 'CS-6114125' as Product_Name,180 as Sold_Quantity,576 as Rank  from dual union all
578  select 'CS-6113693' as Product_Name,180 as Sold_Quantity,577 as Rank  from dual union all
579  select 'CS-4203818' as Product_Name,180 as Sold_Quantity,578 as Rank  from dual union all
580  select 'CS-3402173' as Product_Name,180 as Sold_Quantity,579 as Rank  from dual union all
581  select 'CS-3009562' as Product_Name,180 as Sold_Quantity,580 as Rank  from dual union all
582  select 'CS-5860527' as Product_Name,179 as Sold_Quantity,581 as Rank  from dual union all
583  select 'CS-3001601' as Product_Name,178 as Sold_Quantity,582 as Rank  from dual union all
584  select 'CS-6007001' as Product_Name,178 as Sold_Quantity,583 as Rank  from dual union all
585  select 'CS-4409447' as Product_Name,178 as Sold_Quantity,584 as Rank  from dual union all
586  select 'CS-3011522' as Product_Name,177 as Sold_Quantity,585 as Rank  from dual union all
587  select 'CS-6006859' as Product_Name,177 as Sold_Quantity,586 as Rank  from dual union all
588  select 'CS-5866578' as Product_Name,177 as Sold_Quantity,587 as Rank  from dual union all
589  select 'CS-4700123' as Product_Name,177 as Sold_Quantity,588 as Rank  from dual union all
590  select 'CS-4301232' as Product_Name,177 as Sold_Quantity,589 as Rank  from dual union all
591  select 'CS-3401662' as Product_Name,177 as Sold_Quantity,590 as Rank  from dual union all
592  select 'CS-5100300' as Product_Name,176 as Sold_Quantity,591 as Rank  from dual union all
593  select 'CS-6005193' as Product_Name,176 as Sold_Quantity,592 as Rank  from dual union all
594  select 'CS-3009587' as Product_Name,175 as Sold_Quantity,593 as Rank  from dual union all
595  select 'CS-9200510' as Product_Name,175 as Sold_Quantity,594 as Rank  from dual union all
596  select 'CS-6194215' as Product_Name,175 as Sold_Quantity,595 as Rank  from dual union all
597  select 'CS-6113642' as Product_Name,175 as Sold_Quantity,596 as Rank  from dual union all
598  select 'CS-4402545' as Product_Name,175 as Sold_Quantity,597 as Rank  from dual union all
599  select 'CS-3009569' as Product_Name,174 as Sold_Quantity,598 as Rank  from dual union all
600  select 'CS-8307178' as Product_Name,174 as Sold_Quantity,599 as Rank  from dual union all
601  select 'CS-4405507' as Product_Name,174 as Sold_Quantity,600 as Rank  from dual union all
602  select 'CS-3401654' as Product_Name,173 as Sold_Quantity,601 as Rank  from dual union all
603  select 'CS-9200046' as Product_Name,173 as Sold_Quantity,602 as Rank  from dual union all
604  select 'CS-3402193' as Product_Name,173 as Sold_Quantity,603 as Rank  from dual union all
605  select 'CS-5100333' as Product_Name,172 as Sold_Quantity,604 as Rank  from dual union all
606  select 'CS-6191728' as Product_Name,172 as Sold_Quantity,605 as Rank  from dual union all
607  select 'CS-5105134' as Product_Name,172 as Sold_Quantity,606 as Rank  from dual union all
608  select 'CS-2470361' as Product_Name,171 as Sold_Quantity,607 as Rank  from dual union all
609  select 'CS-5100963' as Product_Name,171 as Sold_Quantity,608 as Rank  from dual union all
610  select 'CS-1400025' as Product_Name,170 as Sold_Quantity,609 as Rank  from dual union all
611  select 'CS-4300855' as Product_Name,170 as Sold_Quantity,610 as Rank  from dual union all
612  select 'CS-3004740' as Product_Name,170 as Sold_Quantity,611 as Rank  from dual union all
613  select 'CS-9302416' as Product_Name,169 as Sold_Quantity,612 as Rank  from dual union all
614  select 'CS-3009584' as Product_Name,168 as Sold_Quantity,613 as Rank  from dual union all
615  select 'CS-9100400' as Product_Name,168 as Sold_Quantity,614 as Rank  from dual union all
616  select 'CS-6021466' as Product_Name,168 as Sold_Quantity,615 as Rank  from dual union all
617  select 'CS-6020684' as Product_Name,168 as Sold_Quantity,616 as Rank  from dual union all
618  select 'CS-6002339' as Product_Name,168 as Sold_Quantity,617 as Rank  from dual union all
619  select 'CS-3401650' as Product_Name,167 as Sold_Quantity,618 as Rank  from dual union all
620  select 'CS-6021467' as Product_Name,167 as Sold_Quantity,619 as Rank  from dual union all
621  select 'CS-3402161' as Product_Name,167 as Sold_Quantity,620 as Rank  from dual union all
622  select 'CS-2390124' as Product_Name,166 as Sold_Quantity,621 as Rank  from dual union all
623  select 'CS-9300059' as Product_Name,166 as Sold_Quantity,622 as Rank  from dual union all
624  select 'CS-6113264' as Product_Name,166 as Sold_Quantity,623 as Rank  from dual union all
625  select 'CS-4402780' as Product_Name,166 as Sold_Quantity,624 as Rank  from dual union all
626  select 'CS-4400023' as Product_Name,166 as Sold_Quantity,625 as Rank  from dual union all
627  select 'CS-4200196' as Product_Name,166 as Sold_Quantity,626 as Rank  from dual union all
628  select 'CS-3009586' as Product_Name,166 as Sold_Quantity,627 as Rank  from dual union all
629  select 'CS-3009575' as Product_Name,164 as Sold_Quantity,628 as Rank  from dual union all
630  select 'CS-9200014' as Product_Name,164 as Sold_Quantity,629 as Rank  from dual union all
631  select 'CS-1301739B' as Product_Name,163 as Sold_Quantity,630 as Rank  from dual union all
632  select 'CS-9202495' as Product_Name,163 as Sold_Quantity,631 as Rank  from dual union all
633  select 'CS-9200311' as Product_Name,163 as Sold_Quantity,632 as Rank  from dual union all
634  select 'CS-1400997' as Product_Name,163 as Sold_Quantity,633 as Rank  from dual union all
635  select 'CS-6112486' as Product_Name,162 as Sold_Quantity,634 as Rank  from dual union all
636  select 'CS-9100432' as Product_Name,162 as Sold_Quantity,635 as Rank  from dual union all
637  select 'CS-7200036' as Product_Name,162 as Sold_Quantity,636 as Rank  from dual union all
638  select 'CS-6112942' as Product_Name,162 as Sold_Quantity,637 as Rank  from dual union all
639  select 'CS-3009571' as Product_Name,161 as Sold_Quantity,638 as Rank  from dual union all
640  select 'CS-6001456' as Product_Name,161 as Sold_Quantity,639 as Rank  from dual union all
641  select 'CS-5102910' as Product_Name,161 as Sold_Quantity,640 as Rank  from dual union all
642  select 'CS-4700951' as Product_Name,161 as Sold_Quantity,641 as Rank  from dual union all
643  select 'CS-3009570' as Product_Name,160 as Sold_Quantity,642 as Rank  from dual union all
644  select 'CS-9202004' as Product_Name,160 as Sold_Quantity,643 as Rank  from dual union all
645  select 'CS-4500126' as Product_Name,159 as Sold_Quantity,644 as Rank  from dual union all
646  select 'CS-9201335' as Product_Name,159 as Sold_Quantity,645 as Rank  from dual union all
647  select 'CS-8306800' as Product_Name,159 as Sold_Quantity,646 as Rank  from dual union all
648  select 'CS-6020493' as Product_Name,159 as Sold_Quantity,647 as Rank  from dual union all
649  select 'CS-6003324' as Product_Name,159 as Sold_Quantity,648 as Rank  from dual union all
650  select 'CS-3005034' as Product_Name,158 as Sold_Quantity,649 as Rank  from dual union all
651  select 'CS-6191088' as Product_Name,158 as Sold_Quantity,650 as Rank  from dual union all
652  select 'CS-3402191' as Product_Name,158 as Sold_Quantity,651 as Rank  from dual union all
653  select 'CS-5208999' as Product_Name,157 as Sold_Quantity,652 as Rank  from dual union all
654  select 'CS-5861078' as Product_Name,156 as Sold_Quantity,653 as Rank  from dual union all
655  select 'CS-8400853' as Product_Name,156 as Sold_Quantity,654 as Rank  from dual union all
656  select 'CS-3009055' as Product_Name,155 as Sold_Quantity,655 as Rank  from dual union all
657  select 'CS-8404034' as Product_Name,155 as Sold_Quantity,656 as Rank  from dual union all
658  select 'CS-5102004' as Product_Name,155 as Sold_Quantity,657 as Rank  from dual union all
659  select 'CS-3009574' as Product_Name,155 as Sold_Quantity,658 as Rank  from dual union all
660  select 'CS-3009069' as Product_Name,154 as Sold_Quantity,659 as Rank  from dual union all
661  select 'CS-6021366' as Product_Name,154 as Sold_Quantity,660 as Rank  from dual union all
662  select 'CS-3402199' as Product_Name,154 as Sold_Quantity,661 as Rank  from dual union all
663  select 'CS-3011528' as Product_Name,153 as Sold_Quantity,662 as Rank  from dual union all
664  select 'CS-6021487' as Product_Name,153 as Sold_Quantity,663 as Rank  from dual union all
665  select 'CS-3009054' as Product_Name,152 as Sold_Quantity,664 as Rank  from dual union all
666  select 'CS-3100018' as Product_Name,152 as Sold_Quantity,665 as Rank  from dual union all
667  select 'CS-3009563' as Product_Name,152 as Sold_Quantity,666 as Rank  from dual union all
668  select 'CS-2002486' as Product_Name,151 as Sold_Quantity,667 as Rank  from dual union all
669  select 'CS-9201001' as Product_Name,151 as Sold_Quantity,668 as Rank  from dual union all
670  select 'CS-6021360' as Product_Name,151 as Sold_Quantity,669 as Rank  from dual union all
671  select 'CS-4202987' as Product_Name,151 as Sold_Quantity,670 as Rank  from dual union all
672  select 'CS-3009573' as Product_Name,151 as Sold_Quantity,671 as Rank  from dual union all
673  select 'CS-3009457' as Product_Name,150 as Sold_Quantity,672 as Rank  from dual union all
674  select 'CS-6113796' as Product_Name,150 as Sold_Quantity,673 as Rank  from dual union all
675  select 'CS-6111004Z' as Product_Name,150 as Sold_Quantity,674 as Rank  from dual union all
676  select 'CS-3401661' as Product_Name,150 as Sold_Quantity,675 as Rank  from dual union all
677  select 'CS-3001605' as Product_Name,149 as Sold_Quantity,676 as Rank  from dual union all
678  select 'CS-9300104' as Product_Name,149 as Sold_Quantity,677 as Rank  from dual union all
679  select 'CS-6113499' as Product_Name,148 as Sold_Quantity,678 as Rank  from dual union all
680  select 'CS-9202910' as Product_Name,148 as Sold_Quantity,679 as Rank  from dual union all
681  select 'CS-9201548' as Product_Name,148 as Sold_Quantity,680 as Rank  from dual union all
682  select 'CS-3009565' as Product_Name,147 as Sold_Quantity,681 as Rank  from dual union all
683  select 'CS-9400298' as Product_Name,147 as Sold_Quantity,682 as Rank  from dual union all
684  select 'CS-6193898' as Product_Name,147 as Sold_Quantity,683 as Rank  from dual union all
685  select 'CS-6117649' as Product_Name,147 as Sold_Quantity,684 as Rank  from dual union all
686  select 'CS-6005929' as Product_Name,147 as Sold_Quantity,685 as Rank  from dual union all
687  select 'CS-5101161' as Product_Name,147 as Sold_Quantity,686 as Rank  from dual union all
688  select 'CS-4401250' as Product_Name,147 as Sold_Quantity,687 as Rank  from dual union all
689  select 'CS-3402195' as Product_Name,147 as Sold_Quantity,688 as Rank  from dual union all
690  select 'CS-3400797' as Product_Name,146 as Sold_Quantity,689 as Rank  from dual union all
691  select 'CS-9200718' as Product_Name,146 as Sold_Quantity,690 as Rank  from dual union all
692  select 'CS-6021367' as Product_Name,146 as Sold_Quantity,691 as Rank  from dual union all
693  select 'CS-3401648' as Product_Name,146 as Sold_Quantity,692 as Rank  from dual union all
694  select 'CS-2470501' as Product_Name,145 as Sold_Quantity,693 as Rank  from dual union all
695  select 'CS-9300105' as Product_Name,145 as Sold_Quantity,694 as Rank  from dual union all
696  select 'CS-6191093' as Product_Name,145 as Sold_Quantity,695 as Rank  from dual union all
697  select 'CS-6004996' as Product_Name,145 as Sold_Quantity,696 as Rank  from dual union all
698  select 'CS-5109110' as Product_Name,145 as Sold_Quantity,697 as Rank  from dual union all
699  select 'CS-3009058' as Product_Name,144 as Sold_Quantity,698 as Rank  from dual union all
700  select 'CS-9308008' as Product_Name,144 as Sold_Quantity,699 as Rank  from dual union all
701  select 'CS-6006858' as Product_Name,144 as Sold_Quantity,700 as Rank  from dual union all
702  select 'CS-6005337' as Product_Name,144 as Sold_Quantity,701 as Rank  from dual union all
703  select 'CS-4400289' as Product_Name,144 as Sold_Quantity,702 as Rank  from dual union all
704  select 'CS-3009056' as Product_Name,143 as Sold_Quantity,703 as Rank  from dual union all
705  select 'CS-9306501' as Product_Name,143 as Sold_Quantity,704 as Rank  from dual union all
706  select 'CS-4900057' as Product_Name,143 as Sold_Quantity,705 as Rank  from dual union all
707  select 'CS-3203278' as Product_Name,143 as Sold_Quantity,706 as Rank  from dual union all
708  select 'CS-3009057' as Product_Name,142 as Sold_Quantity,707 as Rank  from dual union all
709  select 'CS-6112236' as Product_Name,142 as Sold_Quantity,708 as Rank  from dual union all
710  select 'CS-6004010' as Product_Name,142 as Sold_Quantity,709 as Rank  from dual union all
711  select 'CS-6002827' as Product_Name,142 as Sold_Quantity,710 as Rank  from dual union all
712  select 'CS-6002054' as Product_Name,142 as Sold_Quantity,711 as Rank  from dual union all
713  select 'CS-5480212' as Product_Name,142 as Sold_Quantity,712 as Rank  from dual union all
714  select 'CS-4901022' as Product_Name,142 as Sold_Quantity,713 as Rank  from dual union all
715  select 'CS-4300412' as Product_Name,142 as Sold_Quantity,714 as Rank  from dual union all
716  select 'CS-3009053' as Product_Name,141 as Sold_Quantity,715 as Rank  from dual union all
717  select 'CS-9209050' as Product_Name,141 as Sold_Quantity,716 as Rank  from dual union all
718  select 'CS-9202870' as Product_Name,141 as Sold_Quantity,717 as Rank  from dual union all
719  select 'CS-3402197' as Product_Name,141 as Sold_Quantity,718 as Rank  from dual union all
720  select 'CS-3009059' as Product_Name,141 as Sold_Quantity,719 as Rank  from dual union all
721  select 'CS-2470136' as Product_Name,140 as Sold_Quantity,720 as Rank  from dual union all
722  select 'CS-9302415' as Product_Name,140 as Sold_Quantity,721 as Rank  from dual union all
723  select 'CS-6005957' as Product_Name,140 as Sold_Quantity,722 as Rank  from dual union all
724  select 'CS-6000747' as Product_Name,140 as Sold_Quantity,723 as Rank  from dual union all
725  select 'CS-5100275' as Product_Name,140 as Sold_Quantity,724 as Rank  from dual union all
726  select 'CS-3203271' as Product_Name,139 as Sold_Quantity,725 as Rank  from dual union all
727  select 'CS-4706840' as Product_Name,138 as Sold_Quantity,726 as Rank  from dual union all
728  select 'CS-6113913' as Product_Name,138 as Sold_Quantity,727 as Rank  from dual union all
729  select 'CS-6113246' as Product_Name,138 as Sold_Quantity,728 as Rank  from dual union all
730  select 'CS-6000340' as Product_Name,138 as Sold_Quantity,729 as Rank  from dual union all
731  select 'CS-2470506' as Product_Name,137 as Sold_Quantity,730 as Rank  from dual union all
732  select 'CS-9201740' as Product_Name,137 as Sold_Quantity,731 as Rank  from dual union all
733  select 'CS-6004997' as Product_Name,137 as Sold_Quantity,732 as Rank  from dual union all
734  select 'CS-5202130' as Product_Name,137 as Sold_Quantity,733 as Rank  from dual union all
735  select 'CS-4901132' as Product_Name,137 as Sold_Quantity,734 as Rank  from dual union all
736  select 'CS-4100037' as Product_Name,136 as Sold_Quantity,735 as Rank  from dual union all
737  select 'CS-9200300' as Product_Name,136 as Sold_Quantity,736 as Rank  from dual union all
738  select 'CS-6006411' as Product_Name,136 as Sold_Quantity,737 as Rank  from dual union all
739  select 'CS-4701135' as Product_Name,136 as Sold_Quantity,738 as Rank  from dual union all
740  select 'CS-3401647' as Product_Name,135 as Sold_Quantity,739 as Rank  from dual union all
741  select 'CS-9200005' as Product_Name,135 as Sold_Quantity,740 as Rank  from dual union all
742  select 'CS-6112765' as Product_Name,135 as Sold_Quantity,741 as Rank  from dual union all
743  select 'CS-4209496' as Product_Name,135 as Sold_Quantity,742 as Rank  from dual union all
744  select 'CS-3401668' as Product_Name,135 as Sold_Quantity,743 as Rank  from dual union all
745  select 'CS-3003919' as Product_Name,134 as Sold_Quantity,744 as Rank  from dual union all
746  select 'CS-6009770' as Product_Name,134 as Sold_Quantity,745 as Rank  from dual union all
747  select 'CS-6003326' as Product_Name,134 as Sold_Quantity,746 as Rank  from dual union all
748  select 'CS-3009064' as Product_Name,134 as Sold_Quantity,747 as Rank  from dual union all
749  select 'CS-1304819' as Product_Name,133 as Sold_Quantity,748 as Rank  from dual union all
750  select 'CS-6021147' as Product_Name,133 as Sold_Quantity,749 as Rank  from dual union all
751  select 'CS-6006412' as Product_Name,133 as Sold_Quantity,750 as Rank  from dual union all
752  select 'CS-5811502' as Product_Name,133 as Sold_Quantity,751 as Rank  from dual union all
753  select 'CS-4602794' as Product_Name,133 as Sold_Quantity,752 as Rank  from dual union all
754  select 'CS-4100722' as Product_Name,133 as Sold_Quantity,753 as Rank  from dual union all
755  select 'CS-3001177' as Product_Name,132 as Sold_Quantity,754 as Rank  from dual union all
756  select 'CS-9200040' as Product_Name,132 as Sold_Quantity,755 as Rank  from dual union all
757  select 'CS-6021483' as Product_Name,132 as Sold_Quantity,756 as Rank  from dual union all
758  select 'CS-6004999' as Product_Name,132 as Sold_Quantity,757 as Rank  from dual union all
759  select 'CS-5101182' as Product_Name,132 as Sold_Quantity,758 as Rank  from dual union all
760  select 'CS-4206113' as Product_Name,132 as Sold_Quantity,759 as Rank  from dual union all
761  select 'CS-4202290' as Product_Name,132 as Sold_Quantity,760 as Rank  from dual union all
762  select 'CS-3401649' as Product_Name,132 as Sold_Quantity,761 as Rank  from dual union all
763  select 'CS-3009566' as Product_Name,132 as Sold_Quantity,762 as Rank  from dual union all
764  select 'CS-3009564' as Product_Name,132 as Sold_Quantity,763 as Rank  from dual union all
765  select 'CS-3009068' as Product_Name,131 as Sold_Quantity,764 as Rank  from dual union all
766  select 'CS-6195034' as Product_Name,131 as Sold_Quantity,765 as Rank  from dual union all
767  select 'CS-6021169' as Product_Name,131 as Sold_Quantity,766 as Rank  from dual union all
768  select 'CS-6007872' as Product_Name,131 as Sold_Quantity,767 as Rank  from dual union all
769  select 'CS-6005008' as Product_Name,131 as Sold_Quantity,768 as Rank  from dual union all
770  select 'CS-5101099' as Product_Name,131 as Sold_Quantity,769 as Rank  from dual union all
771  select 'CS-4400361' as Product_Name,131 as Sold_Quantity,770 as Rank  from dual union all
772  select 'CS-4100249' as Product_Name,131 as Sold_Quantity,771 as Rank  from dual union all
773  select 'CS-3401670' as Product_Name,131 as Sold_Quantity,772 as Rank  from dual union all
774  select 'CS-3011527' as Product_Name,131 as Sold_Quantity,773 as Rank  from dual union all
775  select 'CS-3011523' as Product_Name,130 as Sold_Quantity,774 as Rank  from dual union all
776  select 'CS-6112237' as Product_Name,130 as Sold_Quantity,775 as Rank  from dual union all
777  select 'CS-6007262' as Product_Name,130 as Sold_Quantity,776 as Rank  from dual union all
778  select 'CS-6006414' as Product_Name,130 as Sold_Quantity,777 as Rank  from dual union all
779  select 'CS-5101181' as Product_Name,130 as Sold_Quantity,778 as Rank  from dual union all
780  select 'CS-4506515' as Product_Name,129 as Sold_Quantity,779 as Rank  from dual union all
781  select 'CS-9408811' as Product_Name,129 as Sold_Quantity,780 as Rank  from dual union all
782  select 'CS-6111661' as Product_Name,129 as Sold_Quantity,781 as Rank  from dual union all
783  select 'CS-3009048' as Product_Name,128 as Sold_Quantity,782 as Rank  from dual union all
784  select 'CS-9202430' as Product_Name,128 as Sold_Quantity,783 as Rank  from dual union all
785  select 'CS-9200035' as Product_Name,128 as Sold_Quantity,784 as Rank  from dual union all
786  select 'CS-8400840' as Product_Name,128 as Sold_Quantity,785 as Rank  from dual union all
787  select 'CS-6000403Z' as Product_Name,128 as Sold_Quantity,786 as Rank  from dual union all
788  select 'CS-4409551' as Product_Name,128 as Sold_Quantity,787 as Rank  from dual union all
789  select 'CS-3009049' as Product_Name,128 as Sold_Quantity,788 as Rank  from dual union all
790  select 'CS-1511013' as Product_Name,127 as Sold_Quantity,789 as Rank  from dual union all
791  select 'CS-9202048' as Product_Name,127 as Sold_Quantity,790 as Rank  from dual union all
792  select 'CS-6111096' as Product_Name,127 as Sold_Quantity,791 as Rank  from dual union all
793  select 'CS-3402160' as Product_Name,127 as Sold_Quantity,792 as Rank  from dual union all
794  select 'CS-1303160' as Product_Name,126 as Sold_Quantity,793 as Rank  from dual union all
795  select 'CS-9201720' as Product_Name,126 as Sold_Quantity,794 as Rank  from dual union all
796  select 'CS-9200716' as Product_Name,126 as Sold_Quantity,795 as Rank  from dual union all
797  select 'CS-9100550' as Product_Name,126 as Sold_Quantity,796 as Rank  from dual union all
798  select 'CS-3009047' as Product_Name,126 as Sold_Quantity,797 as Rank  from dual union all
799  select 'CS-3003926' as Product_Name,125 as Sold_Quantity,798 as Rank  from dual union all
800  select 'CS-5100306' as Product_Name,125 as Sold_Quantity,799 as Rank  from dual union all
801  select 'CS-4700940' as Product_Name,125 as Sold_Quantity,800 as Rank  from dual )
802  select s.*,
803         case
804           when ntile(4) over (order by sold_quantity desc) <= 2 then 'TOP Selling'
805           when ntile(4) over (order by sold_quantity desc) = 3 then 'Medium Selling'
806           when ntile(4) over (order by sold_quantity desc) = 4 then 'Low Selling'
807         end  Category
808  from sample s
809  /
PRODUCT_NAM SOLD_QUANTITY       RANK CATEGORY
----------- ------------- ---------- --------------
CS-1302737           8315          1 TOP Selling
CS-6198202           8186          2 TOP Selling
CS-6193899           5258          3 TOP Selling
CS-1304429           4616          4 TOP Selling
CS-6112576           4297          5 TOP Selling
CS-6198203           4127          6 TOP Selling
CS-5860437           4017          7 TOP Selling
CS-6113063           3407          8 TOP Selling
CS-6190969           3127          9 TOP Selling
CS-6191263           3070         10 TOP Selling
CS-6004977           2801         11 TOP Selling
CS-6193150           2749         12 TOP Selling
CS-6112998           2696         13 TOP Selling
CS-6113064           2644         14 TOP Selling
CS-4800022           2450         15 TOP Selling
CS-6110197           2448         16 TOP Selling
CS-6193897           2443         17 TOP Selling
CS-5105903           2322         18 TOP Selling
CS-1501189           2042         19 TOP Selling
CS-5051034           2023         20 TOP Selling
CS-6194395           1983         21 TOP Selling
CS-6112496           1947         22 TOP Selling
CS-6007962           1920         23 TOP Selling
CS-6112594           1910         24 TOP Selling
CS-6113638           1897         25 TOP Selling
CS-3100112           1865         26 TOP Selling
CS-2401285           1730         27 TOP Selling
CS-6192003           1725         28 TOP Selling
CS-6195622           1663         29 TOP Selling
CS-6113828           1650         30 TOP Selling
CS-4207011           1561         31 TOP Selling
CS-6113826           1559         32 TOP Selling
CS-4301197           1558         33 TOP Selling
CS-6111748           1548         34 TOP Selling
CS-6112595           1544         35 TOP Selling
CS-6111747           1444         36 TOP Selling
CS-4203815           1441         37 TOP Selling
CS-6003917           1441         38 TOP Selling
CS-6113720           1413         39 TOP Selling
CS-6190870           1412         40 TOP Selling
CS-6111884           1411         41 TOP Selling
CS-2470355Z          1406         42 TOP Selling
CS-6112597           1309         43 TOP Selling
CS-3001697           1308         44 TOP Selling
CS-6113724           1306         45 TOP Selling
CS-4803001           1266         46 TOP Selling
CS-6191724           1242         47 TOP Selling
CS-6021013           1227         48 TOP Selling
CS-4207000           1217         49 TOP Selling
CS-6113684           1206         50 TOP Selling
CS-6113799           1201         51 TOP Selling
CS-4800008           1169         52 TOP Selling
CS-5861029           1160         53 TOP Selling
CS-8300239           1156         54 TOP Selling
CS-5201826Z          1139         55 TOP Selling
CS-4100027           1126         56 TOP Selling
CS-2470303Z          1119         57 TOP Selling
CS-3009914           1115         58 TOP Selling
CS-1501145           1108         59 TOP Selling
CS-6005377           1100         60 TOP Selling
CS-6112994           1091         61 TOP Selling
CS-6191726           1087         62 TOP Selling
CS-3011434B          1075         63 TOP Selling
CS-6004976           1072         64 TOP Selling
CS-4301192           1057         65 TOP Selling
CS-8400850           1038         66 TOP Selling
CS-3400793           1031         67 TOP Selling
CS-3202804           1029         68 TOP Selling
CS-4203139           1026         69 TOP Selling
CS-3400785           1018         70 TOP Selling
CS-4800007           1010         71 TOP Selling
CS-4600008            988         72 TOP Selling
CS-3001173            976         73 TOP Selling
CS-6004311            965         74 TOP Selling
CS-4204440            960         75 TOP Selling
CS-4809948            938         76 TOP Selling
CS-6199942            906         77 TOP Selling
CS-3400794            886         78 TOP Selling
CS-6007963            886         79 TOP Selling
CS-1501034            880         80 TOP Selling
CS-2402900            867         81 TOP Selling
CS-1511042            864         82 TOP Selling
CS-6021329            863         83 TOP Selling
CS-3400796            861         84 TOP Selling
CS-6190099            848         85 TOP Selling
CS-6113824            840         86 TOP Selling
CS-5050027            817         87 TOP Selling
CS-6004005            814         88 TOP Selling
CS-4400094            813         89 TOP Selling
CS-6000403            813         90 TOP Selling
CS-6004978            800         91 TOP Selling
CS-4600007            798         92 TOP Selling
CS-4207030            795         93 TOP Selling
CS-6101448            794         94 TOP Selling
CS-3004139            783         95 TOP Selling
CS-6021328            769         96 TOP Selling
CS-3400784            766         97 TOP Selling
CS-6113260            764         98 TOP Selling
CS-5861075            762         99 TOP Selling
CS-3400783            753        100 TOP Selling
CS-6021361            738        101 TOP Selling
CS-6021321            736        102 TOP Selling
CS-6112149            733        103 TOP Selling
CS-1401276            732        104 TOP Selling
CS-3400780            727        105 TOP Selling
CS-5811214            727        106 TOP Selling
CS-3400781            723        107 TOP Selling
CS-6021331            721        108 TOP Selling
CS-6005378            718        109 TOP Selling
CS-6111875            717        110 TOP Selling
CS-2401289            714        111 TOP Selling
CS-3400791            714        112 TOP Selling
CS-6190057            713        113 TOP Selling
CS-6004013            705        114 TOP Selling
CS-6191178            703        115 TOP Selling
CS-5900027            702        116 TOP Selling
CS-6021362            701        117 TOP Selling
CS-4100074            698        118 TOP Selling
CS-1401274            695        119 TOP Selling
CS-6021310            688        120 TOP Selling
CS-4400226            687        121 TOP Selling
CS-6021312            687        122 TOP Selling
CS-3400795            685        123 TOP Selling
CS-4606666            685        124 TOP Selling
CS-4100053            680        125 TOP Selling
CS-9200099            673        126 TOP Selling
CS-6006883            667        127 TOP Selling
CS-8307070            662        128 TOP Selling
CS-6113825            661        129 TOP Selling
CS-5861039            658        130 TOP Selling
CS-6007589            653        131 TOP Selling
CS-3200609            650        132 TOP Selling
CS-6113919            650        133 TOP Selling
CS-6111525            650        134 TOP Selling
CS-3400788            650        135 TOP Selling
CS-5864040            643        136 TOP Selling
CS-5100206            640        137 TOP Selling
CS-6021322            633        138 TOP Selling
CS-6021330            632        139 TOP Selling
CS-3400790            624        140 TOP Selling
CS-4308851            616        141 TOP Selling
CS-4301193            615        142 TOP Selling
CS-8304125            615        143 TOP Selling
CS-6113715            602        144 TOP Selling
CS-5100137            596        145 TOP Selling
CS-4800021            594        146 TOP Selling
CS-5812156            594        147 TOP Selling
CS-3400787            589        148 TOP Selling
CS-9401400            583        149 TOP Selling
CS-3400789            582        150 TOP Selling
CS-6113716            578        151 TOP Selling
CS-4207007            577        152 TOP Selling
CS-6003309            572        153 TOP Selling
CS-6021320            570        154 TOP Selling
CS-4203816            564        155 TOP Selling
CS-6021315            564        156 TOP Selling
CS-3400779            558        157 TOP Selling
CS-6004982            558        158 TOP Selling
CS-4207021            558        159 TOP Selling
CS-3400798            557        160 TOP Selling
CS-4704772            557        161 TOP Selling
CS-6004983            556        162 TOP Selling
CS-6021323            550        163 TOP Selling
CS-6021311            549        164 TOP Selling
CS-1400004            547        165 TOP Selling
CS-3400775            543        166 TOP Selling
CS-3402149            541        167 TOP Selling
CS-6004987            541        168 TOP Selling
CS-3400776            539        169 TOP Selling
CS-6021314            537        170 TOP Selling
CS-3400774            529        171 TOP Selling
CS-6004984            529        172 TOP Selling
CS-4400291            527        173 TOP Selling
CS-6114551            527        174 TOP Selling
CS-6021332            527        175 TOP Selling
CS-3400777            526        176 TOP Selling
CS-6198203I           526        177 TOP Selling
CS-4407056            526        178 TOP Selling
CS-4207036            523        179 TOP Selling
CS-6021313            523        180 TOP Selling
CS-6021325            521        181 TOP Selling
CS-4601202            517        182 TOP Selling
CS-4400233            515        183 TOP Selling
CS-6004989            514        184 TOP Selling
CS-6113795            514        185 TOP Selling
CS-6006400            514        186 TOP Selling
CS-2000117            512        187 TOP Selling
CS-6021358            512        188 TOP Selling
CS-4101055            511        189 TOP Selling
CS-6004986            509        190 TOP Selling
CS-6006860            509        191 TOP Selling
CS-4400004            507        192 TOP Selling
CS-8400011            507        193 TOP Selling
CS-3001151            505        194 TOP Selling
CS-4209425            502        195 TOP Selling
CS-5102939            498        196 TOP Selling
CS-1500321            494        197 TOP Selling
CS-6111883            493        198 TOP Selling
CS-2470508Z           491        199 TOP Selling
CS-5861048            489        200 TOP Selling
CS-4700946            486        201 TOP Selling
CS-4400158            481        202 TOP Selling
CS-1500322            476        203 TOP Selling
CS-3400772            468        204 TOP Selling
CS-5109036            462        205 TOP Selling
CS-5812157            462        206 TOP Selling
CS-4806002            460        207 TOP Selling
CS-3400770            458        208 TOP Selling
CS-9408772            458        209 TOP Selling
CS-6004981            456        210 TOP Selling
CS-6021333            456        211 TOP Selling
CS-6000400            453        212 TOP Selling
CS-4203465            451        213 TOP Selling
CS-6021324            448        214 TOP Selling
CS-5101180            446        215 TOP Selling
CS-4400016            444        216 TOP Selling
CS-1509993            442        217 TOP Selling
CS-6111538            442        218 TOP Selling
CS-6021363            440        219 TOP Selling
CS-6111616            440        220 TOP Selling
CS-6021080            439        221 TOP Selling
CS-9200101            439        222 TOP Selling
CS-6111617            439        223 TOP Selling
CS-6112902            432        224 TOP Selling
CS-4400292            427        225 TOP Selling
CS-9200553            426        226 TOP Selling
CS-6193150I           424        227 TOP Selling
CS-3001150            422        228 TOP Selling
CS-4400095            421        229 TOP Selling
CS-4100028            420        230 TOP Selling
CS-5101237            420        231 TOP Selling
CS-4100029            418        232 TOP Selling
CS-4203819            417        233 TOP Selling
CS-6021316            417        234 TOP Selling
CS-4203814            416        235 TOP Selling
CS-3400771            410        236 TOP Selling
CS-4207034            410        237 TOP Selling
CS-3402146            408        238 TOP Selling
CS-6005948            408        239 TOP Selling
CS-6022054            406        240 TOP Selling
CS-6113251            403        241 TOP Selling
CS-2470360            402        242 TOP Selling
CS-6007131            402        243 TOP Selling
CS-6113694            399        244 TOP Selling
CS-6111664            396        245 TOP Selling
CS-3400320            395        246 TOP Selling
CS-9301013            395        247 TOP Selling
CS-3400786            393        248 TOP Selling
CS-4400367            393        249 TOP Selling
CS-6021359            391        250 TOP Selling
CS-9207400            391        251 TOP Selling
CS-6110292            391        252 TOP Selling
CS-4400501            387        253 TOP Selling
CS-5201255            385        254 TOP Selling
CS-4400057            383        255 TOP Selling
CS-3009915            380        256 TOP Selling
CS-6001354            376        257 TOP Selling
CS-4400500            374        258 TOP Selling
CS-4606648            374        259 TOP Selling
CS-4209503            371        260 TOP Selling
CS-6002053            371        261 TOP Selling
CS-3007869            369        262 TOP Selling
CS-3402143            367        263 TOP Selling
CS-4406340            367        264 TOP Selling
CS-2470498            366        265 TOP Selling
CS-7201101            366        266 TOP Selling
CS-3001176            365        267 TOP Selling
CS-6007130            363        268 TOP Selling
CS-6021364            363        269 TOP Selling
CS-3201150            362        270 TOP Selling
CS-4400364            362        271 TOP Selling
CS-5100224            361        272 TOP Selling
CS-6004990            361        273 TOP Selling
CS-6021295            360        274 TOP Selling
CS-9200417            360        275 TOP Selling
CS-6021014            358        276 TOP Selling
CS-4301145            357        277 TOP Selling
CS-6004991            357        278 TOP Selling
CS-4400022            357        279 TOP Selling
CS-3010211            356        280 TOP Selling
CS-6006864            356        281 TOP Selling
CS-4301195            353        282 TOP Selling
CS-6005196            352        283 TOP Selling
CS-5100297            350        284 TOP Selling
CS-6003916            347        285 TOP Selling
CS-9304860            347        286 TOP Selling
CS-3401666            345        287 TOP Selling
CS-4401257            341        288 TOP Selling
CS-6006035            339        289 TOP Selling
CS-6193656            336        290 TOP Selling
CS-4700948            335        291 TOP Selling
CS-6021292            334        292 TOP Selling
CS-5100227            333        293 TOP Selling
CS-4400055            332        294 TOP Selling
CS-8400846            332        295 TOP Selling
CS-8401165            331        296 TOP Selling
CS-3001148            330        297 TOP Selling
CS-5816892            329        298 TOP Selling
CS-6021491            328        299 TOP Selling
CS-3201149            326        300 TOP Selling
CS-6005338            326        301 TOP Selling
CS-3400130            325        302 TOP Selling
CS-6021365            325        303 TOP Selling
CS-4100075            324        304 TOP Selling
CS-2401287            322        305 TOP Selling
CS-4405378            319        306 TOP Selling
CS-6004993            319        307 TOP Selling
CS-4400290            317        308 TOP Selling
CS-6005909            314        309 TOP Selling
CS-6021317            314        310 TOP Selling
CS-3200610            313        311 TOP Selling
CS-3011520            312        312 TOP Selling
CS-6192005            312        313 TOP Selling
CS-6005195            312        314 TOP Selling
CS-4400147            312        315 TOP Selling
CS-6021372            311        316 TOP Selling
CS-6007004            310        317 TOP Selling
CS-4202289            307        318 TOP Selling
CS-6021326            306        319 TOP Selling
CS-4801402            305        320 TOP Selling
CS-4207012            304        321 TOP Selling
CS-6002052            302        322 TOP Selling
CS-9200385            302        323 TOP Selling
CS-6021494            302        324 TOP Selling
CS-2402087            301        325 TOP Selling
CS-6006884            301        326 TOP Selling
CS-5105854            300        327 TOP Selling
CS-5101066            299        328 TOP Selling
CS-6116600            299        329 TOP Selling
CS-6007003            299        330 TOP Selling
CS-6005950            299        331 TOP Selling
CS-6004992            298        332 TOP Selling
CS-6111388Z           298        333 TOP Selling
CS-6001201            297        334 TOP Selling
CS-6002340            295        335 TOP Selling
CS-3402187            294        336 TOP Selling
CS-9202445            294        337 TOP Selling
CS-1400312            293        338 TOP Selling
CS-3400773            293        339 TOP Selling
CS-5860417            291        340 TOP Selling
CS-6111004            291        341 TOP Selling
CS-5109106            290        342 TOP Selling
CS-3400782            289        343 TOP Selling
CS-6022053            288        344 TOP Selling
CS-4606649            287        345 TOP Selling
CS-6021318            287        346 TOP Selling
CS-2002485            286        347 TOP Selling
CS-3008983            285        348 TOP Selling
CS-3200611            283        349 TOP Selling
CS-6005366            283        350 TOP Selling
CS-3011519            282        351 TOP Selling
CS-6006882            282        352 TOP Selling
CS-2000525            281        353 TOP Selling
CS-6021493            281        354 TOP Selling
CS-4203813            280        355 TOP Selling
CS-6021490            280        356 TOP Selling
CS-4207043            279        357 TOP Selling
CS-6113853            279        358 TOP Selling
CS-4400370            277        359 TOP Selling
CS-6190468            277        360 TOP Selling
CS-4300878            275        361 TOP Selling
CS-6004980            275        362 TOP Selling
CS-5102766            275        363 TOP Selling
CS-6005474            274        364 TOP Selling
CS-4400056            272        365 TOP Selling
CS-6190009            272        366 TOP Selling
CS-6004988            272        367 TOP Selling
CS-5100109            272        368 TOP Selling
CS-3011521            271        369 TOP Selling
CS-3001607            270        370 TOP Selling
CS-4800055            270        371 TOP Selling
CS-6021492            269        372 TOP Selling
CS-2000119            268        373 TOP Selling
CS-5208998            268        374 TOP Selling
CS-5100304            268        375 TOP Selling
CS-3401658            266        376 TOP Selling
CS-3402177            266        377 TOP Selling
CS-3402179            265        378 TOP Selling
CS-6021319            265        379 TOP Selling
CS-3004607            264        380 TOP Selling
CS-5070003            263        381 TOP Selling
CS-6193151            263        382 TOP Selling
CS-3001603            262        383 TOP Selling
CS-8305066            262        384 TOP Selling
CS-3402167            261        385 TOP Selling
CS-5100153            261        386 TOP Selling
CS-3402185            261        387 TOP Selling
CS-9101013            260        388 TOP Selling
CS-5860418            259        389 TOP Selling
CS-4400232            257        390 TOP Selling
CS-6004995            257        391 TOP Selling
CS-5100192            257        392 TOP Selling
CS-2002488            256        393 TOP Selling
CS-9402099            256        394 TOP Selling
CS-6021327            256        395 TOP Selling
CS-2470137            256        396 TOP Selling
CS-3001600            254        397 TOP Selling
CS-9203169            254        398 TOP Selling
CS-5901043            254        399 TOP Selling
CS-4102599            254        400 TOP Selling
CS-4100069            253        401 Medium Selling
CS-6003320            253        402 Medium Selling
CS-3402165            251        403 Medium Selling
CS-6003904            251        404 Medium Selling
CS-4400229            250        405 Medium Selling
CS-6005949            250        406 Medium Selling
CS-1501021            249        407 Medium Selling
CS-8301009            249        408 Medium Selling
CS-5811214I           249        409 Medium Selling
CS-3009585            249        410 Medium Selling
CS-3203277            247        411 Medium Selling
CS-3401657            247        412 Medium Selling
CS-3008976            246        413 Medium Selling
CS-9201321            246        414 Medium Selling
CS-6191082            246        415 Medium Selling
CS-3400792            244        416 Medium Selling
CS-4709900            244        417 Medium Selling
CS-2400318            243        418 Medium Selling
CS-9203002            243        419 Medium Selling
CS-9202840            243        420 Medium Selling
CS-3005224            243        421 Medium Selling
CS-3402171            242        422 Medium Selling
CS-6191087            242        423 Medium Selling
CS-6110326            242        424 Medium Selling
CS-6002341            242        425 Medium Selling
CS-6005194            241        426 Medium Selling
CS-6005951            241        427 Medium Selling
CS-1505165            240        428 Medium Selling
CS-6006037            240        429 Medium Selling
CS-3009583            239        430 Medium Selling
CS-4701023            239        431 Medium Selling
CS-4200188            239        432 Medium Selling
CS-3402181            239        433 Medium Selling
CS-3401659            238        434 Medium Selling
CS-3402163            238        435 Medium Selling
CS-3001157            237        436 Medium Selling
CS-6005947            237        437 Medium Selling
CS-5101038            237        438 Medium Selling
CS-6004979            236        439 Medium Selling
CS-9202240            236        440 Medium Selling
CS-6021054            235        441 Medium Selling
CS-6021495            235        442 Medium Selling
CS-3009588            234        443 Medium Selling
CS-6112436            234        444 Medium Selling
CS-5201549            234        445 Medium Selling
CS-2470600            233        446 Medium Selling
CS-8300085            233        447 Medium Selling
CS-5201089            233        448 Medium Selling
CS-5104815            233        449 Medium Selling
CS-1304432            232        450 Medium Selling
CS-6112823            232        451 Medium Selling
CS-6005952            232        452 Medium Selling
CS-6004003            232        453 Medium Selling
CS-4209427            232        454 Medium Selling
CS-3009582            231        455 Medium Selling
CS-8300126            231        456 Medium Selling
CS-5105904            231        457 Medium Selling
CS-3401656            230        458 Medium Selling
CS-9200539            230        459 Medium Selling
CS-3402183            230        460 Medium Selling
CS-5050023L           228        461 Medium Selling
CS-9200323            228        462 Medium Selling
CS-3008970            227        463 Medium Selling
CS-3402169            227        464 Medium Selling
CS-3008994            227        465 Medium Selling
CS-4900425            226        466 Medium Selling
CS-6194436            226        467 Medium Selling
CS-6006036            226        468 Medium Selling
CS-3008978            225        469 Medium Selling
CS-3401664            225        470 Medium Selling
CS-3008985            224        471 Medium Selling
CS-4400297            223        472 Medium Selling
CS-1401277            222        473 Medium Selling
CS-3008973            222        474 Medium Selling
CS-3008987            221        475 Medium Selling
CS-6194980            220        476 Medium Selling
CS-3008971            219        477 Medium Selling
CS-6193147            219        478 Medium Selling
CS-6006401            219        479 Medium Selling
CS-4100251            219        480 Medium Selling
CS-3008975            218        481 Medium Selling
CS-6009850            218        482 Medium Selling
CS-6006863            218        483 Medium Selling
CS-3008974            217        484 Medium Selling
CS-4304964            216        485 Medium Selling
CS-8302439            216        486 Medium Selling
CS-6006413            216        487 Medium Selling
CS-4209420            215        488 Medium Selling
CS-7201086            215        489 Medium Selling
CS-3008972            214        490 Medium Selling
CS-5201254            214        491 Medium Selling
CS-4207038            214        492 Medium Selling
CS-3401665            214        493 Medium Selling
CS-3402145            213        494 Medium Selling
CS-9101028            213        495 Medium Selling
CS-3008977            212        496 Medium Selling
CS-7203300            212        497 Medium Selling
CS-3401655            211        498 Medium Selling
CS-5072036            211        499 Medium Selling
CS-4400296            211        500 Medium Selling
CS-3401653            210        501 Medium Selling
CS-6006415            210        502 Medium Selling
CS-9200352            209        503 Medium Selling
CS-3001602            208        504 Medium Selling
CS-6190004            208        505 Medium Selling
CS-5811117            208        506 Medium Selling
CS-4405530            208        507 Medium Selling
CS-3008992            208        508 Medium Selling
CS-3008991            208        509 Medium Selling
CS-5861041            206        510 Medium Selling
CS-4309820            205        511 Medium Selling
CS-5861005            205        512 Medium Selling
CS-5106805            205        513 Medium Selling
CS-6004994            203        514 Medium Selling
CS-6193112            203        515 Medium Selling
CS-5101018            202        516 Medium Selling
CS-5103356            202        517 Medium Selling
CS-6002712            201        518 Medium Selling
CS-4700950            200        519 Medium Selling
CS-6191262            200        520 Medium Selling
CS-6006038            200        521 Medium Selling
CS-6005953            200        522 Medium Selling
CS-6000641            200        523 Medium Selling
CS-5107629            200        524 Medium Selling
CS-5050026            200        525 Medium Selling
CS-3001604            199        526 Medium Selling
CS-8300240            199        527 Medium Selling
CS-6005188            199        528 Medium Selling
CS-5102938            199        529 Medium Selling
CS-3008980            199        530 Medium Selling
CS-3001695            198        531 Medium Selling
CS-6110492            198        532 Medium Selling
CS-5107764            198        533 Medium Selling
CS-5862500            197        534 Medium Selling
CS-9202400            197        535 Medium Selling
CS-3008989            196        536 Medium Selling
CS-4400156            196        537 Medium Selling
CS-2401290            195        538 Medium Selling
CS-3009460            194        539 Medium Selling
CS-4800024            194        540 Medium Selling
CS-3401663            194        541 Medium Selling
CS-9300126            193        542 Medium Selling
CS-5050006            192        543 Medium Selling
CS-9306506            192        544 Medium Selling
CS-8302011            192        545 Medium Selling
CS-6021369            192        546 Medium Selling
CS-6021047            192        547 Medium Selling
CS-6002784            192        548 Medium Selling
CS-5100169            192        549 Medium Selling
CS-3008979            191        550 Medium Selling
CS-6164322            191        551 Medium Selling
CS-2002482            190        552 Medium Selling
CS-3001155            189        553 Medium Selling
CS-6113798            189        554 Medium Selling
CS-3200612            187        555 Medium Selling
CS-9203995            187        556 Medium Selling
CS-4402925            187        557 Medium Selling
CS-4400121            186        558 Medium Selling
CS-9208015            186        559 Medium Selling
CS-8400580            186        560 Medium Selling
CS-3008993            185        561 Medium Selling
CS-9300030            185        562 Medium Selling
CS-3402147            185        563 Medium Selling
CS-3009576            185        564 Medium Selling
CS-3009572            185        565 Medium Selling
CS-3001152            184        566 Medium Selling
CS-9202131            184        567 Medium Selling
CS-6021477            184        568 Medium Selling
CS-5101322            183        569 Medium Selling
CS-3011518            182        570 Medium Selling
CS-6191232            182        571 Medium Selling
CS-6003353            182        572 Medium Selling
CS-3008982            181        573 Medium Selling
CS-6004019            181        574 Medium Selling
CS-3008968            180        575 Medium Selling
CS-6114125            180        576 Medium Selling
CS-6113693            180        577 Medium Selling
CS-4203818            180        578 Medium Selling
CS-3402173            180        579 Medium Selling
CS-3009562            180        580 Medium Selling
CS-5860527            179        581 Medium Selling
CS-3001601            178        582 Medium Selling
CS-6007001            178        583 Medium Selling
CS-4409447            178        584 Medium Selling
CS-3011522            177        585 Medium Selling
CS-6006859            177        586 Medium Selling
CS-5866578            177        587 Medium Selling
CS-4700123            177        588 Medium Selling
CS-4301232            177        589 Medium Selling
CS-3401662            177        590 Medium Selling
CS-5100300            176        591 Medium Selling
CS-6005193            176        592 Medium Selling
CS-3009587            175        593 Medium Selling
CS-9200510            175        594 Medium Selling
CS-6194215            175        595 Medium Selling
CS-6113642            175        596 Medium Selling
CS-4402545            175        597 Medium Selling
CS-3009569            174        598 Medium Selling
CS-8307178            174        599 Medium Selling
CS-4405507            174        600 Medium Selling
CS-3401654            173        601 Low Selling
CS-9200046            173        602 Low Selling
CS-3402193            173        603 Low Selling
CS-5100333            172        604 Low Selling
CS-6191728            172        605 Low Selling
CS-5105134            172        606 Low Selling
CS-2470361            171        607 Low Selling
CS-5100963            171        608 Low Selling
CS-1400025            170        609 Low Selling
CS-4300855            170        610 Low Selling
CS-3004740            170        611 Low Selling
CS-9302416            169        612 Low Selling
CS-3009584            168        613 Low Selling
CS-9100400            168        614 Low Selling
CS-6021466            168        615 Low Selling
CS-6020684            168        616 Low Selling
CS-6002339            168        617 Low Selling
CS-3401650            167        618 Low Selling
CS-6021467            167        619 Low Selling
CS-3402161            167        620 Low Selling
CS-2390124            166        621 Low Selling
CS-9300059            166        622 Low Selling
CS-6113264            166        623 Low Selling
CS-4402780            166        624 Low Selling
CS-4400023            166        625 Low Selling
CS-4200196            166        626 Low Selling
CS-3009586            166        627 Low Selling
CS-3009575            164        628 Low Selling
CS-9200014            164        629 Low Selling
CS-1301739B           163        630 Low Selling
CS-9202495            163        631 Low Selling
CS-9200311            163        632 Low Selling
CS-1400997            163        633 Low Selling
CS-6112486            162        634 Low Selling
CS-9100432            162        635 Low Selling
CS-7200036            162        636 Low Selling
CS-6112942            162        637 Low Selling
CS-3009571            161        638 Low Selling
CS-6001456            161        639 Low Selling
CS-5102910            161        640 Low Selling
CS-4700951            161        641 Low Selling
CS-3009570            160        642 Low Selling
CS-9202004            160        643 Low Selling
CS-4500126            159        644 Low Selling
CS-9201335            159        645 Low Selling
CS-8306800            159        646 Low Selling
CS-6020493            159        647 Low Selling
CS-6003324            159        648 Low Selling
CS-3005034            158        649 Low Selling
CS-6191088            158        650 Low Selling
CS-3402191            158        651 Low Selling
CS-5208999            157        652 Low Selling
CS-5861078            156        653 Low Selling
CS-8400853            156        654 Low Selling
CS-3009055            155        655 Low Selling
CS-8404034            155        656 Low Selling
CS-5102004            155        657 Low Selling
CS-3009574            155        658 Low Selling
CS-3009069            154        659 Low Selling
CS-6021366            154        660 Low Selling
CS-3402199            154        661 Low Selling
CS-3011528            153        662 Low Selling
CS-6021487            153        663 Low Selling
CS-3009054            152        664 Low Selling
CS-3100018            152        665 Low Selling
CS-3009563            152        666 Low Selling
CS-2002486            151        667 Low Selling
CS-9201001            151        668 Low Selling
CS-6021360            151        669 Low Selling
CS-4202987            151        670 Low Selling
CS-3009573            151        671 Low Selling
CS-3009457            150        672 Low Selling
CS-6113796            150        673 Low Selling
CS-6111004Z           150        674 Low Selling
CS-3401661            150        675 Low Selling
CS-3001605            149        676 Low Selling
CS-9300104            149        677 Low Selling
CS-6113499            148        678 Low Selling
CS-9202910            148        679 Low Selling
CS-9201548            148        680 Low Selling
CS-3009565            147        681 Low Selling
CS-9400298            147        682 Low Selling
CS-6193898            147        683 Low Selling
CS-6117649            147        684 Low Selling
CS-6005929            147        685 Low Selling
CS-5101161            147        686 Low Selling
CS-4401250            147        687 Low Selling
CS-3402195            147        688 Low Selling
CS-3400797            146        689 Low Selling
CS-9200718            146        690 Low Selling
CS-6021367            146        691 Low Selling
CS-3401648            146        692 Low Selling
CS-2470501            145        693 Low Selling
CS-9300105            145        694 Low Selling
CS-6191093            145        695 Low Selling
CS-6004996            145        696 Low Selling
CS-5109110            145        697 Low Selling
CS-3009058            144        698 Low Selling
CS-9308008            144        699 Low Selling
CS-6006858            144        700 Low Selling
CS-6005337            144        701 Low Selling
CS-4400289            144        702 Low Selling
CS-3009056            143        703 Low Selling
CS-9306501            143        704 Low Selling
CS-4900057            143        705 Low Selling
CS-3203278            143        706 Low Selling
CS-3009057            142        707 Low Selling
CS-6112236            142        708 Low Selling
CS-6004010            142        709 Low Selling
CS-6002827            142        710 Low Selling
CS-6002054            142        711 Low Selling
CS-5480212            142        712 Low Selling
CS-4901022            142        713 Low Selling
CS-4300412            142        714 Low Selling
CS-3009053            141        715 Low Selling
CS-9209050            141        716 Low Selling
CS-9202870            141        717 Low Selling
CS-3402197            141        718 Low Selling
CS-3009059            141        719 Low Selling
CS-2470136            140        720 Low Selling
CS-9302415            140        721 Low Selling
CS-6005957            140        722 Low Selling
CS-6000747            140        723 Low Selling
CS-5100275            140        724 Low Selling
CS-3203271            139        725 Low Selling
CS-4706840            138        726 Low Selling
CS-6113913            138        727 Low Selling
CS-6113246            138        728 Low Selling
CS-6000340            138        729 Low Selling
CS-2470506            137        730 Low Selling
CS-9201740            137        731 Low Selling
CS-6004997            137        732 Low Selling
CS-5202130            137        733 Low Selling
CS-4901132            137        734 Low Selling
CS-4100037            136        735 Low Selling
CS-9200300            136        736 Low Selling
CS-6006411            136        737 Low Selling
CS-4701135            136        738 Low Selling
CS-3401647            135        739 Low Selling
CS-9200005            135        740 Low Selling
CS-6112765            135        741 Low Selling
CS-4209496            135        742 Low Selling
CS-3401668            135        743 Low Selling
CS-3003919            134        744 Low Selling
CS-6009770            134        745 Low Selling
CS-6003326            134        746 Low Selling
CS-3009064            134        747 Low Selling
CS-1304819            133        748 Low Selling
CS-6021147            133        749 Low Selling
CS-6006412            133        750 Low Selling
CS-5811502            133        751 Low Selling
CS-4602794            133        752 Low Selling
CS-4100722            133        753 Low Selling
CS-3001177            132        754 Low Selling
CS-9200040            132        755 Low Selling
CS-6021483            132        756 Low Selling
CS-6004999            132        757 Low Selling
CS-5101182            132        758 Low Selling
CS-4206113            132        759 Low Selling
CS-4202290            132        760 Low Selling
CS-3401649            132        761 Low Selling
CS-3009566            132        762 Low Selling
CS-3009564            132        763 Low Selling
CS-3009068            131        764 Low Selling
CS-6195034            131        765 Low Selling
CS-6021169            131        766 Low Selling
CS-6007872            131        767 Low Selling
CS-6005008            131        768 Low Selling
CS-5101099            131        769 Low Selling
CS-4400361            131        770 Low Selling
CS-4100249            131        771 Low Selling
CS-3401670            131        772 Low Selling
CS-3011527            131        773 Low Selling
CS-3011523            130        774 Low Selling
CS-6112237            130        775 Low Selling
CS-6007262            130        776 Low Selling
CS-6006414            130        777 Low Selling
CS-5101181            130        778 Low Selling
CS-4506515            129        779 Low Selling
CS-9408811            129        780 Low Selling
CS-6111661            129        781 Low Selling
CS-3009048            128        782 Low Selling
CS-9202430            128        783 Low Selling
CS-9200035            128        784 Low Selling
CS-8400840            128        785 Low Selling
CS-6000403Z           128        786 Low Selling
CS-4409551            128        787 Low Selling
CS-3009049            128        788 Low Selling
CS-1511013            127        789 Low Selling
CS-9202048            127        790 Low Selling
CS-6111096            127        791 Low Selling
CS-3402160            127        792 Low Selling
CS-1303160            126        793 Low Selling
CS-9201720            126        794 Low Selling
CS-9200716            126        795 Low Selling
CS-9100550            126        796 Low Selling
CS-3009047            126        797 Low Selling
CS-3003926            125        798 Low Selling
CS-5100306            125        799 Low Selling
CS-4700940            125        800 Low Selling

800 rows selected.
Re: Oracle Percentage by Rank(Top Percentages) [message #690135 is a reply to message #690134] Wed, 23 October 2024 07:25 Go to previous message
born2achieve
Messages: 14
Registered: July 2012
Junior Member
Thank you Mike for the help. appreciated.
Previous Topic: Previous Quarter three months of Start Date and End Dates
Next Topic: Problem with passing values to Function
Goto Forum:
  


Current Time: Fri Nov 08 18:10:08 CST 2024