题解 | #今天的刷题量(一)#
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
SELECT
name,
z cnt
FROM
subject a
LEFT JOIN
(
SELECT
subject_id,
count(id) z,
create_time
FROM
submission
GROUP BY subject_id,create_time
) b
ON a.id=b.subject_id
WHERE b.create_time=current_date
ORDER BY cnt desc,b.subject_id
order by 可以排序未出现在select中的字段
