题解 | #今天的刷题量(一)#
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
# SELECT NOW() -- 2024-04-08 22:08:33
# SELECT SUBSTR(NOW(),1,10) -- 2024-04-08
SELECT
SS.name
,COUNT(1) cnt
FROM submission S
LEFT JOIN subject SS ON S.subject_id = SS.id
WHERE S.create_time = SUBSTR(NOW(),1,10)
GROUP BY S.subject_id ,SS.name
ORDER BY CNT DESC,S.subject_id
;
小天才公司福利 1370人发布