select nama_klub, count(g1.home) + count(g2.away) as 'game', count(if(g1.skor_home>g1.skor_away,1,null)) + count(if(g2.skor_homeg2.skor_away,1,null)) as loss, (count(if(g1.skor_home>g1.skor_away,1,null)) + count(if(g2.skor_home