My question is related to creating a new column in database which counts the number of times a symbol of this game called Totobola (symbols 1, X, 2)

Right now I have the following code where I have one table called Chaves with 2 rows which are the 2 actual 2016 draws of this game.

I want to add 3 columns (total1-counts number of 1's, totalx-counts number of x's, total2-counts number of 2's in each of the 2 draws):

```
CREATE DATABASE chaves_totobola;

CREATE table Chaves
(
    Num_Conc Int identity(1,1) primary key,
    datasort date,
    s1 char(1),
    s2 char(1),
    s3 char(1),
    s4 char(1),
    s5 char(1),
    s6 char(1),
    s7 char(1),
    s8 char(1),
    s9 char(1),
    s10 char(1),
    s11 char(1),
    s12 char(1),
    s13 char(1),
    s14 varchar(5),
    jackpot bit,
    premio money
);

INSERT INTO Chaves (datasort, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, jackpot, premio)
VALUES ('2016-01-03','2','X','X','X','1','2','2','X','1','2','X','X','2','M : 0','1','0'),
       ('2016-01-10','X','2','1','X','1','X','1','1','1','1','1','2','X','M : M','1','0');

```

Can you please help?