select memberno,
count(memberno) as totalmembers,
sum(fee) as total fee
from memberTable
where datediff(day,regdate,getdate())<=3
group by memberno
count(memberno) as totalmembers,
sum(fee) as total fee
from memberTable
where datediff(day,regdate,getdate())<=3
group by memberno
sum(fee) as fee
from memberTable
where datediff(day,getdate(),regdate)<=3