江湖峰哥的博客

-- 测试数据参考 https://www.cnblogs.com/thxj/p/12727589.html SELECT `name`, `course`, `score`, SUM( score ) over ( PARTITION BY `course` ) AS course_score_total , ROUND(AVG(score) over (...

/*测试数据 参考 https://www.cnblogs.com/thxj/p/12727589.html*/ CREATE TABLE `school_score` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(1) DEFAULT NULL, `course` char(10) DEFAULT NULL, `sco...

https://blog.youkuaiyun.com/qq_37350706/article/details/81707862