题解 | #网易云音乐推荐(网易校招笔试真题)#
今天的刷题量(一)
http://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
select name,count(create_time) cnt
from subject s, submission su
where create_time=curdate() and s.id=su.subject_id
group by s.id,name
order by cnt desc,subject_id