求解一SQL难题，高手请进！！！

表table1中有字段:sessionid,pageid,frompage;
sessionid, pageid, frompage
-----------------------------------
2jwgez30qo4 3424 www.164.com
5hwgez356o4 2345 www.165.com
......
下面的语句实现：
将frompage相同的记录汇总，得到结果后将结果按递减进行排序。
结果如：
frompage pageviews
-----------------------------
www.163.com 28139
www.164.com 5902
www.165.com 5309

现在我想在以上基础上将sessionid的参数考虑进来：
就是得到如下结果：
frompage pageviews sessionids
----------------------------------------------
www.163.com 28139 ?
www.164.com 5902 ?
www.165.com 5309 ?

不知道应该怎么处理？请各位高手指导，谢谢！

---------------------------------------------------------------------------
select * into #tt from (select
frompage,(case when pageid is null then rtrim(count(*))else frompage end) as pageviews

from table_01

group by
frompage,pageid with rollup

having
grouping(frompage)=0
)a

where pageviews not like '%.%'

select * from #tt
order by cast(pageviews as int) desc

drop table #tt