无标题文档 SELECT a.cnt_unread,a.e_account ,v_dailyemail_avg.shortname,v_dailyemail_avg.e_m,v_dailyemail_avg.avg_email FROM v_dailyemail_avg left join (SELECT COUNT(e_message.id) AS cnt_unread ,e_message.e_account,e_ebay.shortname FROM e_message,e_ebay WHERE e_message.e_answerstatus = 0 AND e_ebay.id= e_message.e_account GROUP BY e_message.e_account) a on v_dailyemail_avg.shortname =a.shortname WHERE v_dailyemail_avg.e_m ='2018-02' ORDER BY avg_email DESC
日期 账户 本月每日平均邮件数 今天未回邮件数