質問編集履歴
1
CREATE TABLE を追加しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -52,7 +52,17 @@
|
|
|
52
52
|
|
|
53
53
|
### 該当のソースコード
|
|
54
54
|
|
|
55
|
+
create table SHOPINFO (SHOPCODE VARCHAR2(7), ITEMCODE VARCHAR2(7));
|
|
55
56
|
|
|
57
|
+
|
|
58
|
+
|
|
59
|
+
insert into SHOPINFO (SHOPCODE, ITEMCODE)
|
|
60
|
+
|
|
61
|
+
values (AAAA, 0001), (AAAA, 0001), (AAAB, 0002), (AAAB, 0001), (AAAC, 0002);
|
|
62
|
+
|
|
63
|
+
|
|
64
|
+
|
|
65
|
+
### 試したこと
|
|
56
66
|
|
|
57
67
|
select SHOPCODE SHOP, count(A.ITEMCODE) ITEM1, count(B.ITEMCODE) ITEM2
|
|
58
68
|
|
|
@@ -67,10 +77,6 @@
|
|
|
67
77
|
or B.ITEMCODE = '0002'
|
|
68
78
|
|
|
69
79
|
group by SHOPCODE
|
|
70
|
-
|
|
71
|
-
### 試したこと
|
|
72
|
-
|
|
73
|
-
|
|
74
80
|
|
|
75
81
|
|
|
76
82
|
|