求教高手帮我写几个查询语句

Question

oracle数据库 有一个表名SAVEBAL,有两个字段CINO和BALANCE
select * from SAVEBAL  
得到的结果如下:
CINO                       BALANCE                   
192431912                  23423
672990705                  1111
752504068                  456
792565498                  5234
782792953                  873
782792953                  523412
73205301X                  124
73205301X                  3414
73205301X                  3278
73205301X                  56312
68944978X                  1245
743241681                  17334
748862989                  315
672971248                  9843
665857527                  3473
192360253                  2370
27939793X                  3412
731116103                  6756
732051612                  89781.我想把BALANCE这一列所有数据除以226.得到一列新的数据
2.当CINO有相同的值时,既73205301X有好几个相同的,当他们相同时把对应的BALANCE的值相加求和.盼高手帮我写这2个select 语句,十分感谢

Answer 1

1.  SELECT CINO,BALANCE, BALANCE/226 FROM SAVEBAL;
2.  SELECT CINO,SUM(BALANCE) FROM SAVEBAL GROUP BY CINO;

Answer 2

1.  SELECT CINO,BALANCE, BALANCE/226 FROM SAVEBAL; 
2.  SELECT substr(CINO, 1, 8),SUM(BALANCE) FROM SAVEBAL GROUP BY substr(CINO, 1, 8);补充下