回答編集履歴
1
「平均点の高い上位3教科」を追加
test
CHANGED
|
@@ -24,7 +24,11 @@
|
|
|
24
24
|
|
|
25
25
|
) AS T (教科, 点数)
|
|
26
26
|
|
|
27
|
-
GROUP BY 教科
|
|
27
|
+
GROUP BY 教科
|
|
28
|
+
|
|
29
|
+
ORDER BY AVG(点数) DESC
|
|
30
|
+
|
|
31
|
+
FETCH FIRST 3 ROWS ONLY;
|
|
28
32
|
|
|
29
33
|
```
|
|
30
34
|
|
|
@@ -48,6 +52,10 @@
|
|
|
48
52
|
|
|
49
53
|
(SELECT ARRAY[AVG(国語), AVG(算数), AVG(理科), AVG(社会), AVG(英語)] FROM 成績)
|
|
50
54
|
|
|
51
|
-
) AS T (教科, 平均点)
|
|
55
|
+
) AS T (教科, 平均点)
|
|
56
|
+
|
|
57
|
+
ORDER BY T.平均点 DESC
|
|
58
|
+
|
|
59
|
+
FETCH FIRST 3 ROWS ONLY;
|
|
52
60
|
|
|
53
61
|
```
|