max lottery wins by a person at each store

.sql

-- what we want our distinct stores and the max number of wins for a person that played there
SELECT "AGENT NAME", max(count_person_wins), max(sum_person_winnings)
FROM (
        -- gets us the number of wins per person for each store
        SELECT 
                  "AGENT NAME"
                , "FIRSTNAME"
                , "LASTNAME"
                , "CITY"
                , "STATE"
                , COUNT(*) as count_person_wins
                , SUM("PRIZE VALUE") as sum_person_winnings
        FROM data
        WHERE "AGENT NAME" IS NOT NULL
        GROUP BY 1, 2, 3, 4, 5
        ORDER BY "AGENT NAME", COUNT(*) DESC
) as sub_q
GROUP BY 1
ORDER BY max(count_person_wins) DESC;