回答編集履歴
3
カラム名の修正
test
CHANGED
@@ -166,7 +166,7 @@
|
|
166
166
|
|
167
167
|
|
168
168
|
|
169
|
-
SELECT f.name, group_concat(m.name) AS
|
169
|
+
SELECT f.name, group_concat(m.name) AS members
|
170
170
|
|
171
171
|
FROM favorites AS fav
|
172
172
|
|
@@ -188,4 +188,4 @@
|
|
188
188
|
|
189
189
|
|
190
190
|
|
191
|
-
![SELECT結果](ea
|
191
|
+
![SELECT結果](c51e42c76cea4ff42b4c1ee09de1961e.png)
|
2
整形
test
CHANGED
@@ -84,7 +84,7 @@
|
|
84
84
|
|
85
85
|
|
86
86
|
|
87
|
-
create table fruits(
|
87
|
+
create table fruits (
|
88
88
|
|
89
89
|
fruit_id int PRIMARY KEY,
|
90
90
|
|
@@ -94,7 +94,7 @@
|
|
94
94
|
|
95
95
|
|
96
96
|
|
97
|
-
create table favorites(
|
97
|
+
create table favorites (
|
98
98
|
|
99
99
|
member_id int,
|
100
100
|
|
@@ -126,7 +126,9 @@
|
|
126
126
|
|
127
127
|
|
128
128
|
|
129
|
-
SELECT m.name, group_concat(f.name) AS fruits
|
129
|
+
SELECT m.name, group_concat(f.name) AS fruits
|
130
|
+
|
131
|
+
FROM favorites AS fav
|
130
132
|
|
131
133
|
LEFT JOIN members AS m
|
132
134
|
|
@@ -164,7 +166,9 @@
|
|
164
166
|
|
165
167
|
|
166
168
|
|
167
|
-
SELECT f.name, group_concat(m.name) AS fruits
|
169
|
+
SELECT f.name, group_concat(m.name) AS fruits
|
170
|
+
|
171
|
+
FROM favorites AS fav
|
168
172
|
|
169
173
|
LEFT JOIN members AS m
|
170
174
|
|
1
別視点追加
test
CHANGED
@@ -151,3 +151,37 @@
|
|
151
151
|
|
152
152
|
|
153
153
|
![SELECT結果](e93a5b3136557573c74000675208c73c.png)
|
154
|
+
|
155
|
+
|
156
|
+
|
157
|
+
####別視点
|
158
|
+
|
159
|
+
|
160
|
+
|
161
|
+
```SQL
|
162
|
+
|
163
|
+
use test;
|
164
|
+
|
165
|
+
|
166
|
+
|
167
|
+
SELECT f.name, group_concat(m.name) AS fruits FROM favorites AS fav
|
168
|
+
|
169
|
+
LEFT JOIN members AS m
|
170
|
+
|
171
|
+
USING (member_id)
|
172
|
+
|
173
|
+
LEFT JOIN fruits AS f
|
174
|
+
|
175
|
+
USING (fruit_id)
|
176
|
+
|
177
|
+
GROUP BY f.fruit_id;
|
178
|
+
|
179
|
+
```
|
180
|
+
|
181
|
+
|
182
|
+
|
183
|
+
####SELECT結果
|
184
|
+
|
185
|
+
|
186
|
+
|
187
|
+
![SELECT結果](ea1b4532b1d7cee6b316234e268fcf38.png)
|