fang as联系人, count( dx xuhao)as短信数 xin where ax yuefen=4 p by dx duifang order by count(dx xuhao) desc 短信数 t(0.00 ysq1> select dx yue fen as月份, dx duif s联系人, count( dx xuhao) rin where dx yuefen-s group by dx dui fang order by count(dx x 短信数 4 rows in set (0.00 sec) x1 n where queen月份,×uana,联系人,C0unE(xxa)a=短信数 by count (dx xuhao) desc 3.8分析个人近6个月来日平均网络流量和月平均网络流量; SQL语句: select sum( I liuliang )count( distinct( ll yuefen))as"月平均流量(kb)" from luliang select sum( ll liuliangycount( d istinct( lI riqi)as"日平均流量(kb)" from liuliang 果 ysq1> select sum(111iu1iang)/ count( distinct(1 1 yuefen))as"月平均流量(kb)"f ang i 月平均流量(kb) row in set (0.00 ysq1> select sum(111 luliang)/ count( distinct(11riqi))as"日平均流量(kb)"fron 日平均流量(kb) row in set (0.00 sec)17 3.8 分析个人近 6 个月来日平均网络流量和月平均网络流量； SQL 语句：select sum(ll_liuliang)/count(distinct(ll_yuefen)) as "月平均流量(kb)" from liuliang; select sum(ll_liuliang)/count(distinct(ll_riqi)) as "日平均流量(kb)" from liuliang; 结果：