ID_SALE ID_SHOP SALE_RES ID_GOODS
1       1       1        1
2       1       2        2
3       2       4        4
4       3       2        4
5       1       5        1

DROP TABLE IF EXISTS T1;
DROP TABLE IF EXISTS T2;

CREATE TEMPORARY TABLE T1 SELECT ID_SHOP, ID_GOODS, SUM(SALE_RES) as RES FROM SALES GROUP BY ID_SHOP, ID_GOODS;
CREATE TEMPORARY TABLE T2 SELECT ID_SHOP, MAX(RES) as MAX_RES FROM T1 GROUP BY ID_SHOP;
SELECT T2.ID_SHOP, T1.ID_GOODS, MAX_RES FROM T2 JOIN T1 ON T2.ID_SHOP = T1.ID_SHOP AND T2.MAX_RES = T1.RES;