回答編集履歴
1
結果を見やすくした
test
CHANGED
@@ -210,32 +210,32 @@
|
|
210
210
|
|
211
211
|
```
|
212
212
|
|
213
|
-
+---------+-----
|
213
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
214
|
-
|
214
|
+
|
215
|
-
| post_id | A1
|
215
|
+
| post_id | A1 | A2 | B3 | B4 | B5 | B6 | C7 | C8 | D9 | D10 | ALL |
|
216
|
-
|
216
|
+
|
217
|
-
+---------+-----
|
217
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
218
|
-
|
218
|
+
|
219
|
-
| 1 |
|
219
|
+
| 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 |
|
220
|
-
|
220
|
+
|
221
|
-
| 1 |
|
221
|
+
| 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
|
222
|
-
|
222
|
+
|
223
|
-
| 2 |
|
223
|
+
| 2 | 0 | 0 | 1 | 0 | NULL | 1 | 0 | 0 | 1 | 0 | 0 |
|
224
|
-
|
224
|
+
|
225
|
-
| 3 |
|
225
|
+
| 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
|
226
|
-
|
226
|
+
|
227
|
-
| 3 |
|
227
|
+
| 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
|
228
|
-
|
228
|
+
|
229
|
-
| 4 |
|
229
|
+
| 4 | 0 | 0 | 0 | 0 | NULL | 0 | 0 | 0 | 1 | 0 | 0 |
|
230
|
-
|
230
|
+
|
231
|
-
| 5 |
|
231
|
+
| 5 | 1 | 0 | 0 | 0 | NULL | 0 | 0 | 0 | 1 | 0 | 1 |
|
232
|
-
|
232
|
+
|
233
|
-
| 6 |
|
233
|
+
| 6 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
|
234
|
-
|
234
|
+
|
235
|
-
| 7 |
|
235
|
+
| 7 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 |
|
236
|
-
|
236
|
+
|
237
|
-
| 8 |
|
237
|
+
| 8 | 0 | 0 | 0 | 0 | NULL | 1 | 0 | 0 | 1 | 0 | 0 |
|
238
|
-
|
238
|
+
|
239
|
-
+---------+-----
|
239
|
+
+---------+-----+-----+-----+-----+------+-----+-----+-----+-----+-----+-----+
|
240
240
|
|
241
241
|
```
|