質問編集履歴
1
質問本文を修正しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
SELECT * FROM product
|
|
36
36
|
|
|
37
|
-
WHERE product = 'りんご' AND sold_date = '2020-04-01'
|
|
37
|
+
WHERE product = 'りんご' AND sold_date <= '2020-04-01'
|
|
38
38
|
|
|
39
39
|
ORDER BY product , sold_date DESC
|
|
40
40
|
|
|
@@ -58,7 +58,7 @@
|
|
|
58
58
|
|
|
59
59
|
SELECT * FROM product
|
|
60
60
|
|
|
61
|
-
WHERE product = 'みかん' AND sold_date = '2020-05-01'
|
|
61
|
+
WHERE product = 'みかん' AND sold_date <= '2020-05-01'
|
|
62
62
|
|
|
63
63
|
ORDER BY product , sold_date DESC
|
|
64
64
|
|