declare @fromdate datetime declare @season varchar(10) declare @thrudate datetime declare @region int declare @branch int set @fromdate = '01/01/2004' set @thrudate = '05/01/2005' set @region = 16 set @season = 'fall' select count(*) as [regional total], sum(q5)/ count(q5) as [q5 regional mean], sum(q9_1)/ count(q9_1) as [q9_1 regional mean], sum(q9_2)/ count(q9_2) as [q9_2 regional mean], sum(q9_3)/ count(q9_3) as [q9_3 regional mean], sum(q9_4)/ count(q9_4) as [q9_4 regional mean], sum(q10_1)/ count(q10_1) as [q10_1 regional mean], sum(q10_2)/ count(q10_2) as [q10_2 regional mean], sum(q10_3)/ count(q10_3) as [q10_3 regional mean], sum(q10_4)/ count(q10_4) as [q10_4 regional mean], sum(q16)/ count(q16) as [q16 regional mean], sum( rating_a )/ count(rating_a) as [rating_a regional mean], sum( rating_b )/ count(rating_b) as [rating_b regional mean], sum( rating_c )/ count(rating_c) as [rating_c regional mean], sum( rating_d )/ count(rating_d) as [rating_d regional mean], sum( rating_e )/ count(rating_e) as [rating_e regional mean], sum( rating_f )/ count(rating_f) as [rating_f regional mean], sum( rating_g )/ count(rating_g) as [rating_g regional mean], sum( rating_h )/ count(rating_h) as [rating_h regional mean], sum( rating_i )/ count(rating_i) as [rating_i regional mean], sum( rating_j )/ count(rating_j) as [rating_j regional mean], sum( rating_k )/ count(rating_k) as [rating_k regional mean], sum( rating_l )/ count(rating_l) as [rating_l regional mean], sum( rating_m )/ count(rating_m) as [rating_m regional mean], sum( rating_n)/ count(rating_n) as [rating_n regional mean], sum( rating_o )/ count(rating_o) as [rating_o regional mean], sum( rating_p )/ count(rating_p) as [rating_p regional mean] from v_bf_boxscores where [start date] > = @fromdate and [start date] <= @thrudate and season = @season and region = @region select count(*) as [overall total], sum(q5)/ count(q5) as [q5 overall mean], sum(q9_1)/ count(q9_1) as [q9_1 overall mean], sum(q9_2)/ count(q9_2) as [q9_2 overall mean], sum(q9_3)/ count(q9_3) as [q9_3 overall mean], sum(q9_4)/ count(q9_4) as [q9_4 overall mean], sum(q10_1)/ count(q10_1) as [q10_1 overall mean], sum(q10_2)/ count(q10_2) as [q10_2 overall mean], sum(q10_3)/ count(q10_3) as [q10_3 overall mean], sum(q10_4)/ count(q10_4) as [q10_4 overall mean], sum(q16)/ count(q16) as [q16 overall mean], sum( rating_a )/ count(rating_a) as [ rating_a overall mean], sum( rating_b )/ count(rating_b) as [ rating_b overall mean], sum( rating_c )/ count(rating_c) as [ rating_c overall mean], sum( rating_d )/ count(rating_d) as [ rating_d overall mean], sum( rating_e )/ count(rating_e) as [ rating_e overall mean], sum( rating_f )/ count(rating_f) as [ rating_f overall mean], sum( rating_g )/ count(rating_g) as [ rating_g overall mean], sum( rating_h )/ count(rating_h) as [ rating_h overall mean], sum( rating_i )/ count(rating_i) as [ rating_i overall mean], sum( rating_j )/ count(rating_j) as [ rating_j overall mean], sum( rating_k )/ count(rating_k) as [ rating_k overall mean], sum( rating_l )/ count(rating_l) as [ rating_l overall mean], sum( rating_m )/ count(rating_m) as [ rating_m overall mean], sum( rating_n)/ count(rating_n) as [ rating_n overall mean], sum( rating_o )/ count(rating_o) as [ rating_o overall mean], sum( rating_p )/ count(rating_p) as [ rating_p overall mean] from v_bf_boxscoreswhere [start date] > = @fromdate and [start date] <= @thrudate