Calculate %

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