回答編集履歴
1
追記
test
CHANGED
@@ -4,7 +4,11 @@
|
|
4
4
|
|
5
5
|
```sql
|
6
6
|
|
7
|
-
SELECT `id`, `text`, count(F.id) as fav FROM Tweet T
|
7
|
+
SELECT `id`, `text`, count(F.id) as fav FROM Tweet T
|
8
|
+
|
9
|
+
LEFT JOIN Favorite F ON T.id = F.tweet_id
|
10
|
+
|
11
|
+
GROUP BY T.id
|
8
12
|
|
9
13
|
```
|
10
14
|
|