something like this?
QUERY:
SELECT country, profession, MAX(money) AS money
FROM
( SELECT u.country, g.profession, SUM(um.money) AS money
FROM user_money um
JOIN users u ON u.id = um.user_id
JOIN groups g ON g.id = um.group_id
GROUP BY g.profession, u.country
ORDER BY um.money DESC
) t
GROUP BY country
ORDER BY money DESC
OUTPUT:
+---------------+------------+-------+
| country | profession | money |
+---------------+------------+-------+
| Luxembourg | Hacker | 200 |
| Albania | Hacker | 120 |
| United States | Boss | 55 |
+---------------+------------+-------+
5
solved MySQL Select from three tables [closed]