what i get.
select b.WINS+a.WINS from
(select teams.tname, COUNT(*) WINS
from teams, results
where teams.tname = results.home and results.hruns > results.vruns
group by teams.tname) b,
(select tname,count(*) as WINS
from teams, results
where teams.tname=results.visitor and results.vruns > results.hruns
group by teams.tname)a;
B.WINS+A.WINS
-------------
3
4
4
2
4
5
6
6
4
6
3
B.WINS+A.WINS
-------------
4
4
2
4
4
5
5
3
5
what i need to accomplish.
TEAM WINS
-------------------- ----------
Cubs 5
Diamondbacks 4
Cardinals 4
Braves 3
Indians 2