Get the Maximum (Max) value BUT separate for EACH item

[Alexandre Salomé]

Hello,

I am needing help exporting a MySQL report.
I have a base of sellers and sales. I need to get the value of the biggest sale (MAX) of each seller. (and not a bigest value of all them).

Today I use the following syntax to fetch the values ​​from the table:

select B.name, REPLACE (JSON_EXTRACT (A.attributes, '$ .Sale'), '.', ',')
from tc_sales A
join tc_sellers B
ONDE
fixtime between '2018-09-01' and '2018-09-30'
limit 18000000000000000000;

Thanks for the future help