MySQL How to get the first line of a subquery by using the aggregate function

This is my request:

TO SELECT
COUNT (runs_scored) - SUM (IF (extra_type_id = 4, 1, 0)) as balls,
SUM (runs_scored) + SUM (IF (extra_type_id IN (2, 4),
extra_runs,
0)) AS works,
SUM (IF (kind_out IN (1, 2, 4, 6, 7, 8)),
1
0)) AS Wickets
OF
ball_by_ball BBB
LEFT JOINT
`database`.batsman_scored BS USING (match_id, over_id, ball_id, innings_no)
LEFT JOINT
`database`.extra_runs ER USING (match_id, over_id, ball_id, innings_no)
LEFT JOINT
`database`.wicket_taken WT USING (match_id, over_id, ball_id, innings_no)
OR
bowler = 70
GROUP BY match_id
ORDER BY Wickets DESC, Tracks;

This is the output:

+ ------- + ------ + --------- +
| Balls | Shopping | Counters |
+ ------- + ------ + --------- +
| 24 | 28 | 3 |
| 24 | 23 | 2 |
| 24 | 32 | 2 |
| 24 | 23 | 1 |
| 18 | 27 | 1 |
| 12 | 10 | 0 |
| 12 | 17 | 0 |
| 6 | 18 | 0 |
| 18 | 19 | 0 |
| 18 | 28 | 0 |
+ ------- + ------ + --------- +

This is my last request:

TO SELECT
SUM (Balls) AS Balls,
SUM (Runs) AS Runs,
SUM (Wickets) AS Wickets
OF
(TO SELECT
COUNT (runs_scored) - SUM (IF (extra_type_id = 4, 1, 0)) as balls,
SUM (runs_scored) + SUM (IF (extra_type_id IN (2, 4), extra_runs, 0)) AS executes,
SUM (IF (kind_out IN (1, 2, 4, 6, 7, 8), 1, 0) AS Wickets
OF
ball_by_ball BBB
JOIN LEFT `database`.batsman_scored BS USING (match_id, over_id, ball_id, innings_no)
JOIN LEFT `database`.extra_runs ER USING (match_id, over_id, ball_id, innings_no)
JOIN LEFT at `database`.wicket_taken WT USING (match_id, over_id, ball_id, innings_no)
OR
bowler = 70
GROUP BY match_id
ORDER BY Wickets DESC, Tracks) AS A;

This is the output:

+ ------- + ------ + --------- +
| Balls | Shopping | Counters |
+ ------- + ------ + --------- +
| 180 | 225 | 9 |
+ ------- + ------ + --------- +

But I want to get the maximum wickets and racing as below:

+ ------- + ------ + --------- + --------- +
| Balls | Shopping | Counters | Max (W / R) |
+ ------- + ------ + --------- + --------- +
| 180 | 225 | 9 | 3/28 |
+ ------- + ------ + --------- + --------- +

Right here 3 are wickets and 28 are racing that I received Subquery first Row. Now, how can I do this from my last query? I need to have Subquery first Row values ‚Äč‚Äčthat already sorted according to my needs. I have tried WINDOWS FUNCTION it does not work.