3.7分析个人短信通话中每月前5名联系人 (7) select dx yuefen as月份 dx guifang as联系人, count( dx xuhao)as短信数 from duanxin where dx yuefen=l group by dx duifang order by count(dx xuhao) desc limit 5 select dx yuefen as月份, dx guifang as联系人 count(dx xuhao)as短信数from duanxin where dx yuefen=2 group by dx duifang order by count(dx xuhao)desc limit 5: select dx yuefen as月份, dx huifang as联系人 count(dx xuhao)as短信数from duanxin where dx yuefen=3 group by dx duifang order by count(dx xuhao)desc limit 5 select dx yuefen as月份 dx guifang as联系人 count( dx xuhao)as短信数from duanxin where dx yuefen=4 group by dx duifang order by count(dx xuhao)desc limit 5 select dx yuefen as月份 dx guifang as联系人 count( dx xuhao)as短信数from duanxin where dx yuefen=5 group by dx duifang order by count(dx xuhao)desc limit 5 select dx yuefen as月份, dx guifang as联系人, count(dx xuhao)as短信数from duanxin where dx yuefen=6 group by dx duifang order by count(dx xuhao)desc limit 5 果15 3.7 分析个人短信通话中每月前 5 名联系人； （7）select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=1 group by dx_duifang order by count(dx_xuhao) desc limit 5; select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=2 group by dx_duifang order by count(dx_xuhao) desc limit 5; select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=3 group by dx_duifang order by count(dx_xuhao) desc limit 5; select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=4 group by dx_duifang order by count(dx_xuhao) desc limit 5; select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=5 group by dx_duifang order by count(dx_xuhao) desc limit 5; select dx_yuefen as 月份,dx_duifang as 联系人,count(dx_xuhao) as 短信数 from duanxin where dx_yuefen=6 group by dx_duifang order by count(dx_xuhao) desc limit 5; 结果：