How to summarize Bridge results?
Based on the comments, this is one possible solution:


select a.NS, Sum(a.MPNS) from
(select ns, MPNS from match_points
union all
select ew, MPEW from match_points) a
group by a.ns


which returns the required results.

SQLFiddle version of the data here - http://www.sqlfiddle.com/#!2/7e473/11