SELECT isimler, sube, SUM(adet) FROM tablo GROUP BY isimler, sube



SELECT sube, SUM(adet) FROM tablo GROUP BY sube