求一个sql语句，麻烦大家了，谢谢

Question

现在数据格式如下，需要将数据累加，结果如下
3
6
5
3mysql> SELECT o.xs, o.s, o.m, o.l, o.xl, o.xxl, o.xxxl FROM xxxxxx o;+------+-------+------+------+------+------+------+
| xs   | s     | m    | l    | xl   | xxl  | xxxl |
+------+-------+------+------+------+------+------+
|      | 1     | 2    |      |      |      |      |
| 1,2, | ,3,   | ,,   | ,,   | ,,   | ,,   | ,,   |
|      | 2     | 3    |      |      |      |      |
|      |       | 1    | 2    |      |      |      |
|      | 1     | 2    |      |      |      |      |
|      |       | 2    | 3    |      |      |      |
| 1    | 2     | 3    |      |      |      |      |
| 1,,  | 1,2,2 | ,3,2 | ,,   | ,,   | ,,   | ,,   |
+------+-------+------+------+------+------+------+

Answer 1

就是   o.xs+o.s+o.m+o.l+o.xl+o.xxl+o.xxxl  得出我想要的结果

Answer 2

create table ss(xs int,s int);
insert into ss select 2,0 union all
select 1,20 union all select 3,5;
select sum(xs+s) from ss group by xs;====query result(3 records)
sum(xs+s) 
21 
2 
8