select Producer, weight,pickup,pickupdate, scc, (Avg(scc)/Count(pickup)) As Avg
from v_pp_ProducerLoadsAndLabs
where pickupdate between '4-21-2010' and '4-23-2010' and producer = '1650'
group by Producer, weight,pickup,pickupdate, scc
thats what i have so far. It works but i attached a...