1.select d.dt,a.area,d.songid from t_user a,(select * from t_user b,t_play c where b.area=a.area and  c.dt=d.dt and b.userid=c.userid order by c.play_cnt desc limit 0,3) e ,t_play  d group by d.dt,a.area having e.area=a.area and d.dt=e.dt and a.userid=d.userid ; 2 select  (select count(*) from  t_user, t_play where t_user.userid=t_play.userid and t_play.dt=20180502 and  t_user.userid  in (select * from t_user a, t_play b where a.userid=b.userid and b=20180501))/(select count(*)from t_user, t_play where t_user.userid=t_play.userid and t_play.dt=20180501)