Create an SQL function to calculate %.
seq SSN %
1 a 50
2 a 50
1 b 33
2 b 33
3 b 34
1 c 100
perc = 100 / (count ssn )
usage: select ssn per (ssn) from t1
this is just a sample - we can have any number of sequences.
the coder must be proficient in UDF & supply the function as quickly as possible