回答編集履歴

手なおし

2017/04/01 22:36

投稿

スコア1221

test CHANGED Viewed

@@ -18,7 +18,7 @@
   p1.user_id,
-  SUM(p1.point) as total,
+  SUM(p1.point) AS total,
   expiration
@@ -28,19 +28,19 @@
 LEFT JOIN
-  (SELECT user_id, SUM(point) as expiration
+  (SELECT user_id, SUM(point) AS expiration
   FROM points
   WHERE expiration_date < DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY)
-  group by user_id)
+  GROUP BY user_id)
 AS p2
 ON p1.user_id = p2.user_id
-group by user_id;
+GROUP BY user_id;
 ```

ちょっと修正

2017/04/01 22:36

投稿

スコア1221

test CHANGED Viewed

@@ -32,7 +32,9 @@
   FROM points
-  WHERE expiration_date < DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY) group by user_id)
+  WHERE expiration_date < DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY)
+  group by user_id)
 AS p2