質問編集履歴
1
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
|
|
8
8
|
|
|
9
|
-
|
|
9
|
+
■データ
|
|
10
10
|
|
|
11
11
|
販売日,商品,売上数量
|
|
12
12
|
|
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
|
31
|
-
|
|
31
|
+
■欲しい結果
|
|
32
32
|
|
|
33
33
|
販売日,商品,売上数量
|
|
34
34
|
|
|
@@ -91,3 +91,25 @@
|
|
|
91
91
|
2019-12-09,ばなな,0
|
|
92
92
|
|
|
93
93
|
2019-12-10,ばなな,0
|
|
94
|
+
|
|
95
|
+
|
|
96
|
+
|
|
97
|
+
■定義
|
|
98
|
+
|
|
99
|
+
create table test(urdate date,shohin character varying(10),suryo numeric(10,0));
|
|
100
|
+
|
|
101
|
+
insert into test values('2019-12-01','りんご',9);
|
|
102
|
+
|
|
103
|
+
insert into test values('2019-12-04','りんご',5);
|
|
104
|
+
|
|
105
|
+
insert into test values('2019-12-07','りんご',4);
|
|
106
|
+
|
|
107
|
+
insert into test values('2019-12-04','みかん',3);
|
|
108
|
+
|
|
109
|
+
insert into test values('2019-12-01','ばなな',8);
|
|
110
|
+
|
|
111
|
+
insert into test values('2019-12-03','ばなな',1);
|
|
112
|
+
|
|
113
|
+
insert into test values('2019-12-05','ばなな',2);
|
|
114
|
+
|
|
115
|
+
insert into test values('2019-12-07','ばなな',6);
|