回答編集履歴
1
結果を見やすくした
answer
CHANGED
|
@@ -104,18 +104,18 @@
|
|
|
104
104
|
実行結果
|
|
105
105
|
|
|
106
106
|
```
|
|
107
|
-
+---------+-----
|
|
107
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
|
108
|
-
| post_id | A1
|
|
108
|
+
| post_id | A1 | A2 | B3 | B4 | B5 | B6 | C7 | C8 | D9 | D10 | ALL |
|
|
109
|
-
+---------+-----
|
|
109
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
|
110
|
-
| 1 |
|
|
110
|
+
| 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 |
|
|
111
|
-
| 1 |
|
|
111
|
+
| 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
|
|
112
|
-
| 2 |
|
|
112
|
+
| 2 | 0 | 0 | 1 | 0 | NULL | 1 | 0 | 0 | 1 | 0 | 0 |
|
|
113
|
-
| 3 |
|
|
113
|
+
| 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
|
|
114
|
-
| 3 |
|
|
114
|
+
| 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
|
|
115
|
-
| 4 |
|
|
115
|
+
| 4 | 0 | 0 | 0 | 0 | NULL | 0 | 0 | 0 | 1 | 0 | 0 |
|
|
116
|
-
| 5 |
|
|
116
|
+
| 5 | 1 | 0 | 0 | 0 | NULL | 0 | 0 | 0 | 1 | 0 | 1 |
|
|
117
|
-
| 6 |
|
|
117
|
+
| 6 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
|
|
118
|
-
| 7 |
|
|
118
|
+
| 7 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 |
|
|
119
|
-
| 8 |
|
|
119
|
+
| 8 | 0 | 0 | 0 | 0 | NULL | 1 | 0 | 0 | 1 | 0 | 0 |
|
|
120
|
-
+---------+-----
|
|
120
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
|
121
121
|
```
|