Table1 ID Amount
1 10
2 20
3 30
4 40
5 50
6 60
7 70
8 80
results:
Query1 pct ID
11.11 4
13.89 5
16.67 6
19.44 7
22.22 8
16.67 Other
so 4,5,6,7,8 are the five highest clients with pct being their percentage of the total (360). The other clients (1-3) sum up to 60 which is 16.67% of the...