The days in which I was able to take a process that were running for hours in production and get them to run in just minutes or less.

The...

Racing

Just another way around the barn.
-- How far the Player is Behind the Player ahead of them.
WITH Rank_Scores_CTE AS
(
SELECT s.playername AS Player,
    s.points AS...

And you really don't want a table called service and a field called service.  This will be very confusing.

I created it as a temp table, but is this what you want?
SELECT [service], vehicle,
    COUNT(*) AS Quantity,
    SUM(subtotal) AS subtotal,
    SUM(TaxAmount) AS TaxAmount,
    SUM(total) AS Total
FROM #jobs
GROUP BY [service], vehicle
;