ysq1> select th fangshi as方式, th yuefen as月份,sum( th shichang)as"信总时 anshi, th yuefen; 通信总时(秒) 260 被被被 1115方式,sm( th shichang)/comr(inet( yuefen)a 月平均时长(秒 2046.0000 3085.4000 rows in set(0.00 sec) 34分析个人每月语音通信中郑州市和非郑州市主叫和被叫的总时长 34分析个人每月前5名语音主叫联系人和被叫联系人及其通信时 长 select th yuefen as月份, th guifang as联系人 th fangshi as主被 H4, um(th shichang) from tonghua where th fangshi='EA4' and th yuefen=l group by th duifang order by sum(th shichang) desc limit 5; select th yuefen as月份 th duif ang as联系人 th fangshi as主被 叫sum( h shichang) from tonghua where th fangs主叫 and th yuefen=2 group by th duifang order by sum(th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 Hy, sum(th shichang) from tonghua where th fangshi='EH4' and th yuefen=3 group by th duifang order by sum(th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 HL, um(th shichang) from tonghua where th fangshi=E H4' and th yuefen=4 group th duifang order by sum(th shichang) desc limit 5 1010 3.4 分析个人每月语音通信中郑州市和非郑州市主叫和被叫的总时长； 3.4 分析个人每月前 5 名语音主叫联系人和被叫联系人及其通信时 长； select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=1 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=2 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=3 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=4 group by th_duifang order by sum(th_shichang) desc limit 5;