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