08-26-2014 09:40 AM
I want to calculate the proportions of positive alphas. So the number in my column are (0,1)
so, the proportion of positive alphas is equal to sum of A /number of observations(which is 4 here)=2/4
08-26-2014 09:44 AM
simplest solution, IMO:
/* create table want as */
select sum(a) from have;
Need further help from the community? Please ask a new question.