It is close to what I wrote in my example.

Your query returns this:

DealerIDTire RepairsOfThisTyreRepairCount

1 235/60R18 102V 4 9

1 225/65R17 102T 3 9

1 205/55R16 89H 1 9

1 205/70R15 89H 1 9

2 225/65R17 102T 1 1

I need it to return this:

DealerIDTire RepairsOfThisTyreRepairCount PercentOfTotalRepairOrders

1 235/60R18 102V4 10 40

1 225/65R17 102T3 10 30

1 205/55R16 89H1 10 10

2 225/65R17 102T1 3 33

The RepairCount is the total number of repair orders in Table 1. The record with DealerID 1 and Tire 205/70R15 89H is not included since the 3 records above it make up the top 80%.